Re: sequences what does ::text mean ? - Mailing list 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