Re: Issue With PQftable()

From: Terry Lee Tucker <terry(at)esc1(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Issue With PQftable()
Date: 2005-12-12 13:49:06
Message-ID: 200512120849.06024.terry@esc1.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Richard,

Thanks for the response. I see your point. I've been using the table oid to
find a node in a linked list of structures that define several attributes of
a column in relation to the interface. Matching on the column name doesn't
work because some columns share the same name across tables and this function
is a generic one working on all the interfaces; however, I can give the
column a prefix with the AS portion of the SELECT statement that would give
me a clue as to what to do next. I think I have a workaround.

Thanks for the help...

On Monday 12 December 2005 07:20 am, Richard Huxton saith:
> Terry Lee Tucker wrote:
> > There are several tables involved in the query. Note that
> > "my_func(column_3)" from above does some formatting of the data. I issue
> > the command with PQsendQuery(). When loading a widget with data, I have a
> > need of knowing the table oid from which the data came. I have been using
> > PQftable() to get that information, but when I added the
> > "my_func(column_3)" to the query, the value of PQftable() for each of the
> > columns referenced by calls to my_func() comes back as zero.
>
> But my_func(column) can do anything with your data. What if I write:
>
> CREATE FUNCTION my_func(int4) RETURNS int4 AS 'SELECT 2' LANGUAGE SQL;
>
> Here it doesn't matter what data I pass into the function I always get
> "2" back, so how can you say the data comes from a table?
>
> Now, since there clearly isn't a way to answer your original question,
> maybe you need a different question. What do you use the table oid for?
> --
> Richard Huxton
> Archonet Ltd
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2005-12-12 14:11:32 Re: Silent installation of postgres
Previous Message Frank van Vugt 2005-12-12 13:16:21 Re: PL/pgSQL : notion of deferred execution