Re: sequences what does ::text mean ?

From: Ewald Geschwinde <webmaster(at)geschwinde(dot)net>
To: Henk Schets <henk(at)poppunt(dot)be>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: sequences what does ::text mean ?
Date: 2002-07-03 10:05:18
Message-ID: 3D22CC5E.4060409@geschwinde.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Ewald

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Oliver Elphick 2002-07-03 10:58:09 Re: sequences what does ::text mean ?
Previous Message Henk Schets 2002-07-03 09:20:03 sequences what does ::text mean ?