[GENERAL] Re: Can you combine text variable together to referenece a VIEW name ?

2007-04-09 Thread Lew
Bigjim wrote: Hi there, I am trying to combine 2 text variable togther to form the name of a VIEW. example SELECT * FROM ( 'april'||'may') ; The table (or view) part is not a character string but an identifier. -- Lew ---(end of broadcast

Re: [GENERAL] Deleted Flag/Unique Constraint

2007-04-02 Thread Lew
on this matter. -- Lew ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] coalesce for null AND empty strings

2007-04-02 Thread Lew
don't you write one? I recommend sticking with the SQL semantics instead of trying to change them. -- Lew ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] coalesce for null AND empty strings

2007-04-02 Thread Lew
emphatically not the same as an empty string. It is not wise to mess with the fundamental mathematics of SQL. Get used to the fact that NULL is not empty string; embrace the fact and learn to love it. -- Lew ---(end of broadcast)--- TIP 3: Have you

Re: [GENERAL] Deleted Flag/Unique Constraint

2007-04-02 Thread Lew
if portability of the full semantics is an issue, be careful. -- Lew ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Arrays instead of join tables

2007-04-02 Thread Lew
to me to re-invent the network database model, which lost out to the relational model decades ago. -- Lew ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

<    1   2