On 18 May 2001 18:03:25 +0200, Peter Asemann wrote:
> In mySQL it was like this:
>
> insert into users values ('','peter','my_pass');
>
> In PostGreSQL this does not work. The only thing that works is
>
> insert into users (name,pass) values ('peter','my_pass');
Yes, thats not nice in postgresql. But there is a workaround.
Put the 'default' fields at the end:
---------------8<---------------------
CREATE TEMP TABLE tempo (test bool, id serial);
INSERT INTO tempo values (true);
SELECT * from tempo;
---------------8<---------------------
test | id
------+----
t | 1
(1 row)
Hope it helps.
P.S.: I'd really like postgresql to behave like mysql in this context
P.S.S.: Perhaps also in the GROUP BY context :)
--
Nabil Sayegh