Re: [SQL] ENUM like data type

2005-06-28 Thread Nick Johnson
been used as a pseudo-enum of sorts? -Nick Johnson ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [SQL] preventing deletion of a row

2005-06-06 Thread Nick Johnson
tablename WHERE OLD.fixed = TRUE DO INSTEAD NOTHING; -Nick Johnson ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[SQL] (Mis)using the PostgreSQL planner to get estimated row counts

2005-05-31 Thread Nick Johnson
Is this something that's reasonable to do in the first place? I'm not sure if extensions are supposed to be allowed to delve into PostgreSQL's internals this much. 3) Are there any other gotchas around this area? For example, there's a lot going on with Snapshots and ActiveS

[SQL] (Mis)using the PostgreSQL planner to get estimated row counts

2005-05-30 Thread Nick Johnson
hots and ActiveSnapshot that I really don't have any idea about. -Nick Johnson ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])