From: | Andrew McMillan <andrew(at)catalyst(dot)net(dot)nz> |
---|---|
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:14 |
Message-ID: | 1025693894.17205.883.camel@kant.mcmillan.net.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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?
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Jore | 2002-07-03 12:48:51 | Re: Importing complete txt file with column names |
Previous Message | Oliver Elphick | 2002-07-03 10:58:09 | Re: sequences what does ::text mean ? |