| From: | Zoltan Boszormenyi <zboszor(at)dunaweb(dot)hu> |
|---|---|
| To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
| Cc: | pgsql-hackers(at)postgresql(dot)org, josh(at)agliodbs(dot)com, Tino Wildenhain <tino(at)wildenhain(dot)de> |
| Subject: | Re: SERIAL type feature request |
| Date: | 2005-12-04 07:57:10 |
| Message-ID: | 4392A156.9020708@dunaweb.hu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Peter Eisentraut írta:
>Josh Berkus wrote:
>
>
>>I believe that our SERIAL/SEQUENCE stuff is already in compliance
>>with the SQL standard for sequences (in SQL03). Why would we change
>>it?
>>
>>
>
>Because your belief is wrong, but Zoltan's proposal is not getting is
>closer.
>
>
>
OK, what does the standard say on SERIAL for specifying the start value?
And about this:
<last serial value was e.g. 307>
insert into mytable (serial_id, ...) values (500, ...);
delete from mytable where serial_id = 500;
In Informix, this is a way to start the next serial value at 501.
Best regards,
Zoltán
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mario Weilguni | 2005-12-04 08:58:15 | Re: Strange left join problems in 8.1 |
| Previous Message | Zoltan Boszormenyi | 2005-12-04 07:53:22 | Re: SERIAL type feature request |