On Sunday 20 February 2005 00:25, Tom Lane wrote: > Robert Treat <[EMAIL PROTECTED]> writes: > > If I am understanding this correctly, they could only be displayed if > > selected explicitly right? > > That's always been true. The behavior at the level of SQL commands > wouldn't change. The question is whether any apps out there examine > pg_attribute and expect these rows to be present. Most of the code > I've seen that examines pg_attribute explicitly disregards rows with > attnum < 0 ... >
One of us is not understanding the other :-) I'm asking if I have a piece of code that does something like select attname from pg_attribute where attrelid = 'stock'::regclass::oid with the intent of displaying all those attnames, then the "system atts" will no longer show up in that list, correct? I'm asking cause I have some code that does something like this at work so wondering if I need to do some further investigating come Tuesday morning. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]