| From: | Clinton Adams <clinton(at)vote-smart(dot)org> |
|---|---|
| To: | Bruno Wolff III <bruno(at)wolff(dot)to> |
| Cc: | pgsql-php(at)postgresql(dot)org |
| Subject: | Re: How do I get the rec-id from an insert. |
| Date: | 2002-08-30 00:52:46 |
| Message-ID: | 200208291852.46769.clinton@vote-smart.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-php |
Bruno -
Three sequences are involved in the INSERT. If one sequence were involved,
then the expressions would be evaluated left to right, at least from what I
can tell through my tests. Not something I would ever use...or rely on, for
that matter.
On Thu August 29 2002 16:58, Bruno Wolff III graced us with the following -
> > insert into c values (nextval('crecid'), currval('arecid'),
> > currval('brecid'))
>
> Is it documented that the above is reliable? I don't remember ever reading
> that expressions are evaluated in the order they appear in a select
> statement.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | dr_sad(surguttel) | 2002-08-30 06:26:04 | Re: Where can I get error messages? |
| Previous Message | Bruno Wolff III | 2002-08-29 22:58:15 | Re: How do I get the rec-id from an insert. |