Postgres Pro
Downloads
Home   >   mailing lists

Re: Question on pgpsql function - Mailing list pgsql-admin

From Tom Lane
Subject Re: Question on pgpsql function
Date
Msg-id 11751.1176074446@sss.pgh.pa.us
Whole thread Raw
In response to Question on pgpsql function  (Karthikeyan Sundaram <skarthi98@hotmail.com>)
List pgsql-admin
Tree view 
Karthikeyan Sundaram <skarthi98@hotmail.com> writes:
>  I am getting an error message
> ERROR:  function substr(bit, integer, integer) does not existHINT:  No func=
> tion matches the given name and argument types. You may need to add explici=
> t type casts.CONTEXT:  SQL function "week_func"

I think you want substring() not substr().

            regards, tom lane

pgsql-admin by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [SQL] Question on pgpsql function
Next
From: Karthikeyan Sundaram
Date:
Subject: Another question in functions