Re: [GENERAL] record OID to table

2006-03-04 Thread Karsten Hilbert
On Fri, Mar 03, 2006 at 09:01:53PM -0700, Michael Fuhr wrote: Could you explain what you're trying to do without reference to how you're trying to do it? It sounds like the goal is to take an arbitrary string and find out what rows in what tables contain that string. Is that right? If so

[GENERAL] record OID to table

2006-03-03 Thread Yudie Pg
How can I possible to find out what table a record belong to from record's oid? Thanks Yudie

Re: [GENERAL] record OID to table

2006-03-03 Thread Martijn van Oosterhout
On Fri, Mar 03, 2006 at 11:31:40AM -0600, Yudie Pg wrote: How can I possible to find out what table a record belong to from record's oid? You can't. An OID doesn't identify the record since it's not guarenteed to be unique (usually). In a query you can use tableoid but that's about it. Hope

Re: [GENERAL] record OID to table

2006-03-03 Thread Michael Fuhr
On Fri, Mar 03, 2006 at 11:31:40AM -0600, Yudie Pg wrote: How can I possible to find out what table a record belong to from record's oid? You can't, short of querying every table that has an oid column. However, you could determine the table from the record's tableoid column. Where are you

Re: [GENERAL] record OID to table

2006-03-03 Thread Michael Fuhr
[Please copy the mailing list on replies.] On Fri, Mar 03, 2006 at 01:42:15PM -0600, Yudie Pg wrote: I was trying to make a indexing table that use fulltext indexing that could store all string values from the other tables in the database. I hope that can use record oid as the key and can be