Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA31245 for ; Thu, 2 Mar 2000 10:46:07 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id KAA08876; Thu, 2 Mar 2000 10:46:03 -0500 (EST) To: "Emils Klotins" cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] date_part - multiple values in format? In-reply-to: <200003021508.RAA08695@omega.bkc.lv> References: <200003021508.RAA08695@omega.bkc.lv> Comments: In-reply-to "Emils Klotins" message dated "Thu, 02 Mar 2000 17:10:07 +0200" Date: Thu, 02 Mar 2000 10:46:03 -0500 Message-ID: <8873.952011963@sss.pgh.pa.us> From: Tom Lane "Emils Klotins" writes: > I am looking basically for something like: > select date_part('%d %m %y', now()::datetime); I think to_char() addresses this in 7.0, although it doesn't use the strftime formatting conventions (blame Oracle for that ;-)). See http://www.postgresql.org/docs/postgres/functions2569.htm > Will there be a possibility of string concatenation in 7.x so that > I don't have to put all the concats in brackets? (ie. currently I > have to: ((((X || Y) || Z ) || A) || B) > which is of course also rather clumsy and leads to lots of > typos in case of more complex expressions. What? regression=# select 'a'::text || 'b'::text || 'c'::text; ?column? ---------- abc (1 row) 6.5.3 behaves the same ... regards, tom lane