Re: [GENERAL] Problem with Crosstab (Concatenate Problem)

2010-11-03 Thread Joseph Conway
On 11/1/10 11:54 PM, Stefan Schwarzer wrote: >> SELECT * FROM >>crosstab( >>'SELECT name, year_start, value FROM foo ORDER BY 1', >>'SELECT DISTINCT year_start FROM foo' >>) >> AS ct(name varchar, y_2010 float8, y_2011 float8); > Hi Joe. Thanks a lot for the suggestions. Tried it o

Re: [GENERAL] Does anyone know anything about "qecr" or "brahmabrahmabrahmabrahma()"

2009-10-21 Thread Joseph Conway
Radcon Entec wrote: > Greetings! > > PostgreSQL just crashed on a client's machine. There are several > strange things in the log file for today. Among the strangest is the > following: > > 2009-10-21 12:28:01 EDT anneal 94S-CAPS1.akst.com ERROR: syntax error > at or near "qecr" at character 2

Re: [GENERAL] Code tables, conditional foreign keys?

2009-05-24 Thread Joseph Conway
Conrad Lender wrote: So I guess it's like Stefan Keller said in a different thread today: "Know when to break the rules." Amen. As I have seen posted on another recent thread, anyone who tells you that one way is *always* correct, and the other is *always* incorrect, is lying. Joe -- Sent