[SQL] Fill array with series

Is there a single function that will generate a series and return an array? The best I've come up with is to combine array_agg and generate_series: SELECT array_agg(generate_series) FROM generate_series(5, 23); array_agg - {5,6,7,8,9,10,11,1

Re: [SQL] Fill array with series

Hello no, there is nothing similar. Regards Pavel 2012/3/22 Lee Hachadoorian : > Is there a single function that will generate a series and return an array? > The best I've come up with is to combine array_agg and generate_series: > > SELECT array_agg(generate_series) FROM generate_series(5, 23

[SQL] ignore case in where clause

I am currently using lower(column) = '' for matching case insensitive. I know that there are ways to do this with regular expressions too. I recently noticed that including even one lower causes severe performance issues (from 290ms to over 80Kms). What is the best way, performance wise, to do cas

Re: [SQL] ignore case in where clause

On Thu, 2012-03-22 at 16:26 -0400, Edward W. Rouse wrote: > I am currently using lower(column) = '' for matching case insensitive. I > know that there are ways to do this with regular expressions too. I recently > noticed that including even one lower causes severe performance issues (from > 290ms

Re: [SQL] ignore case in where clause

That was exactly it, Thanks. > -Original Message- > From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql- > ow...@postgresql.org] On Behalf Of Guillaume Lelarge > Sent: Thursday, March 22, 2012 4:39 PM > To: Edward W. Rouse > Cc: pgsql-sql@postgresql.org > Subject: Re: [SQL] ignore case