From: | Nabil Sayegh <nsmail(at)sayegh(dot)de> |
---|---|
To: | postgresql <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: inserting values like in mySQL |
Date: | 2001-05-22 21:53:15 |
Message-ID: | 20010522214949.768BB14EE63@gerstung3.net-lab.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Smith | 2001-05-22 22:34:13 | Re: inserting values like in mySQL |
Previous Message | Nabil Sayegh | 2001-05-22 21:51:24 | Re: inserting values like in mySQL |