| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Karthikeyan Sundaram <skarthi98(at)hotmail(dot)com> |
| Cc: | postgres admin <pgsql-admin(at)postgresql(dot)org>, postgres sql <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Question on pgpsql function |
| Date: | 2007-04-08 23:20:46 |
| Message-ID: | 11751.1176074446@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-sql |
Karthikeyan Sundaram <skarthi98(at)hotmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Karthikeyan Sundaram | 2007-04-09 01:59:13 | Another question in functions |
| Previous Message | Adrian Klaver | 2007-04-08 20:22:11 | Re: [SQL] Question on pgpsql function |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dirk Jagdmann | 2007-04-09 00:07:16 | Re: MD5 sums of large objects |
| Previous Message | Adrian Klaver | 2007-04-08 20:22:11 | Re: [SQL] Question on pgpsql function |