Search Postgresql Archives

Re: Issue With PQftable()

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux