From: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk> |
---|---|
To: | Ewald Geschwinde <webmaster(at)geschwinde(dot)net> |
Cc: | Henk Schets <henk(at)poppunt(dot)be>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: sequences what does ::text mean ? |
Date: | 2002-07-03 10:58:09 |
Message-ID: | 1025693889.14876.5.camel@linda |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Wed, 2002-07-03 at 11:05, Ewald Geschwinde wrote:
> Henk Schets wrote:
> >In a table I have as a default value nextval('seq_auteurs'). What's
the difference with nextval('seq_auteurs'::text) ?
> The difference ist nextval('seq_autheurs') you get an integer back and
> with the second one it casts the integer to text and returns a text value
That would be "nextval('seq_auteurs')::text", with the cast outside the
parentheses.
"nextval('seq_auteurs'::text)" converts 'seq_auteurs' to text before
using it to identify the sequence for nextval(). Since 'seq_auteurs' is
already text, this is a null operation.
Oliver
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew McMillan | 2002-07-03 10:58:14 | Re: sequences what does ::text mean ? |
Previous Message | Ewald Geschwinde | 2002-07-03 10:05:18 | Re: sequences what does ::text mean ? |