Hi,
When I copied a function call into an SQL-statement and executed it, I
got the message 'Aggregate function calls may not be nested'. Does that
mean this is the case in standard SQL or is this specifically PostgreSQL?
Thanks
Huub
---(end of broadcast)--
Gee, this sounds familiar.
See the question (
http://archives.postgresql.org/pgsql-sql/2002-11/msg00191.php ) I posted of
a similar nature a couple of days ago.
We decided to wait for 7.3/7.4 and in the mean time we're using CAST (
'constant value' as numeric ).
Thanks,
Paul Ogden
Claresco Corp
I'm using pgAdmin II version 1.3.82 , psqlODBC 7.2.3 ,
postgreSQl 7.2.1. There is a problem when I do an SQL query
with a field of numeric, for eample NUMERIC (10.2). Following
staement causes an error such as "Unable to indentify an
operator '>' for type 'numeric' and 'double precision'..."
There's no sense waiting as 7.3 is about to go RC1, and only the most
improbable circumstances would lead to a system catalog change at this
point. (If you do make a diagram, please post it to the group )
Robert Treat
On Wed, 2002-11-13 at 16:28, Jean-Luc Lachance wrote:
> Thanks, I know about t
On Sun, 10 Nov 2002, Tom Lane wrote:
> "Zhidian Du" <[EMAIL PROTECTED]> writes:
> > CREATE TABLE Link (
> >Protein_ID oid
> >CONSTRAINT one
> >REFERENCES Protein (oid)
> >ON DELETE CASCADE,
> >Link varchar(128)
> > );
> > When I insert a record into this child table, it says
>
