pplies the filter
in a.
Can you send the outputs of "explain " for these two and
let us know what version of PG this is?
Bye, Chris.
--
Chris Mair
http://www.1006.org
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
/www.postgresql.org/docs/8.1/static/functions-string.html
This for example might work for you:
select translate('A98526', 'A', '0');
Bye, Chris.
--
Chris Mair
http://www.1006.org
---(end of broadcast)---
TIP 9: In v
nk online at
http://developer.postgresql.org/cvsweb.cgi/~checkout~/pgsql/contrib/dblink/README.dblink?rev=1.12.4.1;content-type=text%2Fplain
Bye,
Chris.
--
Chris Mair
http://www.1006.org
---(end of broadcast)---
TIP 9: In versions below 8.0, th
og.pg_constraint r,
> pg_catalog.pg_class c WHERE c.oid = r.conrelid;
I forgot to mention, it's tested on 8.1...
Bye, Chris.
--
Chris Mair
http://www.1006.org
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
ype as
contraint_type, pg_catalog.pg_get_constraintdef(r.oid, true) as
constraint_definition FROM pg_catalog.pg_constraint r,
pg_catalog.pg_class c WHERE c.oid = r.conrelid;
Bye,
Chris
--
Chris Mair
http://www.1006.org
---(end of broadcast)---
TIP
ration strategy.
> I know this is long shot but I hope someone can shed some light.
If you're on pgsql-performance@postgresql.org as well, we might continue
discussion there.
Bye :)
Chris.
--
Chris Mair
http://www.1006.org
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
