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?