Re: create function problem - Mailing list pgsql-sql

From Kancha .
Subject Re: create function problem
Date
Msg-id 20020319100343.28739.qmail@web14902.mail.yahoo.com
Whole thread Raw
In response to Re: create function problem  ("Matteo Beccati" <m.beccati@crpsoftware.it>)
Responses Re: create function problem
List pgsql-sql
> Hi,
> 
> > create function usage(text)
> > returns numeric
> > as 'select ceil(sum(sessiontime)/60) from
> ath_online
> > where loginname=\'$1\' and  startdate >= (select
> > startdate from cst_package where status=\'t\' and
> > cid=(select cid from cst_customer where
> > loginname=\'$1\'));'
> > language 'sql';
> 
> Try to replace \'$1\' with just $1 (i.e. loginname =
> $1).
> 

the argument is a string so it has to be enclosed in
quotes and \ is to escape the quote. replacing with
just $1 will give error like following:
Unable to identify an operator '=$' for types
'varchar' and 'int4'       You will have to retype this query using an
explicit cast



__________________________________________________
Do You Yahoo!?
Yahoo! Sports - live college hoops coverage
http://sports.yahoo.com/


pgsql-sql by date:

Previous
From: "Matteo Beccati"
Date:
Subject: Re: create function problem
Next
From: Kelly Burkhart
Date:
Subject: optimizer tuning/forcing correct index use