Re: nextval::text

On Tue, Mar 04, 2003 at 10:54:34PM -0800, John Smith wrote:
>
> I was just wondering why in the generated schema nextval is cast to text rather than int?

I think you're misreading. It's the string being passed to nextval that is
being cast to text, not the return value.

> John
>
> CREATE TABLE x (
> id integer DEFAULT nextval('"x_id_seq"'::text) NOT NULL,
> name character varying(30) NOT NULL
> );
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Tax Center - forms, calculators, tips, and more
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Support bacteria! They're the only culture some people have.