hat would appear to
impact this:
standard_conforming_strings (set to ON)
backslash_quote (set to SAFE_ENCODING)
Changing the server setting doesn't appear to have an impact. Does
anybody have a suggestion on what I'm missing?
Garrett Murphy
as mm
from generate_series(1,60,1) AS s(a)
) months
LEFT OUTER JOIN foo
ON
months.mm=to_char(foo_date_created,'-MM')
GROUP BY months.mm
I’m sure you can adapt this to your needs.
Garrett M
Are you able to set up a SELECT query to get the result you want? If
you are, it's as simple as putting "CREATE VIEW viewname AS ", followed
by your query.
Garrett Murphy
_
From: pgsql-sql-ow...@postgresql.org
[mailto:pgsql-sql-ow...
