On Sun, Jul 10, 2011 at 1:35 PM, hatem gamal elzanaty wrote:
> hi all,
> can you tell me what is similar to like operator in mysql for postgresql
> hatem gamal
In postgresql ilike is like mysql's case insensitive like. like in
postgres is case sensitive.
--
Sent via pgsql-sql mailing list (pgs
hi all,
can you tell me what is similar to like operator in mysql for postgresql
hatem gamal
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
2011/7/10 Uwe Bartels :
> Hi Pavel,
>
> is it posible to get this running even with dynamic sql?
> I didn't write that. I'm using execute to run this create table
>
probably yes
postgres=# do $$
declare x text;
begin
execute e'explain(format yaml) select * from data where value = \'a\'' int
Hi Pavel,
is it posible to get this running even with dynamic sql?
I didn't write that. I'm using execute to run this create table
best regards,
Uwe
On 10 July 2011 21:20, Pavel Stehule wrote:
> Hello
>
>
>
> 2011/7/10 Uwe Bartels :
> > Hi,
> >
> > I'm starting up a datawarehouse with pat
Hi Pavel,
I don't believe it. the second answer on sunday evening within half an hour.
and it works. excellent!!!
best regards,
Uwe
On 10 July 2011 21:20, Pavel Stehule wrote:
> Hello
>
>
>
> 2011/7/10 Uwe Bartels :
> > Hi,
> >
> > I'm starting up a datawarehouse with patitioning.
> > my etl
Hi Adrian,
yes. but this is not the cause for the syntax error.
thanks,
Uwe
On 10 July 2011 21:20, Adrian Klaver wrote:
> On Sunday, July 10, 2011 11:54:10 am Uwe Bartels wrote:
> > Hi,
> >
> > I'm starting up a datawarehouse with patitioning.
> > my etl processes write directly into the co
Hello
2011/7/10 Uwe Bartels :
> Hi,
>
> I'm starting up a datawarehouse with patitioning.
> my etl processes write directly into the corresponding partitions instead of
> using triggers.
>
> The reports I run in the datawarehouse are stored in a cache within the same
> database.
> Now I'd like t
On Sunday, July 10, 2011 11:54:10 am Uwe Bartels wrote:
> Hi,
>
> I'm starting up a datawarehouse with patitioning.
> my etl processes write directly into the corresponding partitions instead
> of using triggers.
>
> The reports I run in the datawarehouse are stored in a cache within the
> same d
Hi,
I'm starting up a datawarehouse with patitioning.
my etl processes write directly into the corresponding partitions instead of
using triggers.
The reports I run in the datawarehouse are stored in a cache within the same
database.
Now I'd like to store besides the results the dependencies to t
