Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT INTO using Views? - Mailing list pgsql-general

From Tom Lane
Subject Re: SELECT INTO using Views?
Date
Msg-id 8265.1168360409@sss.pgh.pa.us
Whole thread Raw
In response to Re: SELECT INTO using Views?  ("Jeanna Geier" <jgeier@apt-cafm.com>)
List pgsql-general
Tree view 
"Jeanna Geier" <jgeier@apt-cafm.com> writes:
> If I cast the entire operation to an INT: ...
> I'm getting an 'ERROR:  integer out of range' error returned when I run my
> SELECT statement:

Perhaps use floor() instead?

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Operator performance question
Next
From: "Matthew T. O'Connor"
Date:
Subject: Re: Autovacuum Improvements