Kumar,
pg_class.relname is type "name". You are trying to compare it to p_tablename
which is type "varchar". Try changing your function definition to:
CREATE OR REPLACE FUNCTION public.desc_table(name)
HTH
George
SNIP
> CREATE OR REPLACE FUNCTION public.desc_table(varchar)
> RETURNS re
uery using an explicit cast
replace
WHERE c.relname = p_tablename
with
WHERE c.relname::varchar = p_tablename
>
> I have write many functions of the same structure and executed with out
> problems. Where I am doing wrong here.
>
> Please shed some light.
>
> Regards
> K
essage -
From: "Richard Huxton" <[EMAIL PROTECTED]>
To: "Kumar" <[EMAIL PROTECTED]>; "Jordan S. Jones" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, October 17, 2003 2:54 PM
Subject: Re: [SQL] Object description at Client Window
> On
gt;
Sent: Friday, October 17, 2003 2:54 PM
Subject: Re: [SQL] Object description at Client Window
> On Friday 17 October 2003 09:44, Kumar wrote:
> > Hi ,
> >
> > Jordan, thanks for ur reply. But I am not asking that.
> >
> > I want to get all the column names of any
On Friday 17 October 2003 09:44, Kumar wrote:
> Hi ,
>
> Jordan, thanks for ur reply. But I am not asking that.
>
> I want to get all the column names of any table at the PgAdmin3 SQL Window.
> To make it more clear, actually i wanted to send the table name as the
> input parameter for a function a
, 2003 11:50
AM
Subject: Re: [SQL] Object description at
Client Window
give psql -E a try.. It will display any internal SQL commands
that it uses.Jordan S. JonesKumar wrote:
Dear Friends,
I am working with Postgres 7.3.4 on RH linux
7.2.
I could
give psql -E a try.. It will display any internal SQL commands that it
uses.
Jordan S. Jones
Kumar wrote:
Dear Friends,
I am working with Postgres 7.3.4 on RH linux 7.2.
I could get into the command prompt to describe a
table structure.
Welcome to psql, the Postg
Dear Friends,
I am working with Postgres 7.3.4 on RH linux 7.2.
I could get into the command prompt to describe a table
structure.
Welcome to psql, the PostgreSQL interactive
terminal.
Type: \copyright for distribution
terms \h for help with SQL
commands \? for help on i
