Re: sequences what does ::text mean ?

On Wed, 2002-07-03 at 22:05, Ewald Geschwinde wrote:
> Henk Schets wrote:
>
> >Hi,
> >
> >In a table I have as a default value nextval('seq_auteurs').  What's the difference with
nextval('seq_auteurs'::text)? 
> >
> >Henk
> >
> >
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 4: Don't 'kill -9' the postmaster
> >
> >
> >
> >
> >
> 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

No you won't - that ::text is _inside_ the brackets.  You'll still get
an INT4.

There really is no difference.  I think the second might be the somewhat
pedantic output of pg_dump.

Regards,
                    Andrew.
--
--------------------------------------------------------------------
Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St, Wellington
WEB: http://catalyst.net.nz/        PHYS: Level 2, 150-154 Willis St
DDI: +64(4)916-7201    MOB: +64(21)635-694    OFFICE: +64(4)499-2267
       Are you enrolled at http://schoolreunions.co.nz/ yet?