Re: [SQL] to_char() accepting invalid dates?

Bruce Momjian, 20.07.2011 03:03: Well, to_char() is based on Oracle's to_char(). How does Oracle handle such a date? Oracle throws an error for the above example: SQL> select to_date('20110231', 'MMDD') from dual; select to_date('20110231', 'MMDD') from dual * ERROR

[SQL] compile postgres with visual studio 2010

Hi I would like to build Postgres from source with the visual studio 2010 compiler Is it supported? Is there any document which describes the process of the implementation? Thanks, Yuval Sofer BMC Software CTM&D Business Unit DBA Team 972-52-4286-282 yuval_so...@bmc.com -- Sent via pgsq

Re: [SQL] compile postgres with visual studio 2010

The documentation only mentions Visual Studio 2005 and Visual Studio 2008, but I see no reason why it shouldn't work. Check out the requirements listed in the documentation: http://www.postgresql.org/docs/9.0/interactive/install-windows-full.html On Wed, Jul 20, 2011 at 3:55 AM, Sofer, Yuval wro

[SQL] LTREE extension and "order by"

Hi, in postgreSQL (with LTREE extension) database I have the following table "comments": id BIGINT /* id */ article_id BIGINT /*article-id */ parent_id BIGINT comment TEXT path LTREE level INTEGER /* level */ with the following rows: id article_id comment parent_id path level 1 1 1 1 2 1 b

Re: [SQL] LTREE extension and "order by"

Hi. You should convert path to integer[]. 2011/7/20, Ivan Polak : > Hi, > > in postgreSQL (with LTREE extension) database I have the following > table "comments": > > id BIGINT /* id */ > article_id BIGINT /*article-id */ > parent_id BIGINT > comment TEXT > path LTREE > level INTEGER /* level */