Re: [SQL] is there a refactor

check_two check_test array_test (29 rows) -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql -- Peter Steinheuser psteinheu...@myyearbook.com

Re: [SQL] Determine length of numeric field

@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql -- Peter Steinheuser psteinheu...@myyearbook.com

Re: [SQL] Drawing a blank on some SQL

(pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql -- Peter Steinheuser psteinheu...@myyearbook.com

Re: [SQL] select c1, method(c2) group by c1 returns all values of c2 for c1

: 1, val1, val2, val3 2, val1 3, val5, val6 Thanks a lot! -- Lu Ying -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql -- Peter Steinheuser psteinheu...@myyearbook.com

Re: [SQL] Getting top 2 by Category

; On Wed, Jan 19, 2011 at 3:11 PM, Carla cgourof...@hotmail.com wrote: 2011/1/11 Peter Steinheuser psteinheu...@myyearbook.com Well, if yoi have PG 8.4 and above - select categoryid, magazineid from ( select row_number() over (partition by categoryid order by categoryid,magazineid asc

Re: [SQL] Getting top 2 by Category

INTO magazinecategory( magazinecategoryid, magazineid, categoryid) VALUES (6, 12,4); The results I want are CategoryID MagazineID 3 2 3 8 4 10 4 11 *Pam Ozer* -- Peter Steinheuser psteinheu...@myyearbook.com

Re: [SQL] concatenate question

(s). You might need to add explicit type casts. Thanks. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql -- Peter Steinheuser psteinheu...@myyearbook.com

Re: [SQL] concatenate question

. On Tue, 2010-12-07 at 16:43 -0500, Peter Steinheuser wrote: I think the HINT is what you need to look at. Cast both columns to text. On Tue, Dec 7, 2010 at 4:37 PM, Tony Capobianco tcapobia...@prospectiv.com wrote: Here's my table: plsql_dw=# \d

Re: [SQL] backup and document views and user functions

4534502 Snail Mail: Amuka D.N Merom Hagalil 13802 Israel Email: harel...@ergolight-sw.com -- Peter Steinheuser psteinheu...@myyearbook.com