[SQL] Easier way to 'strip' on multiple matches?

I need to strip out all spaces, and all \' from a string ... is there an easier way then doing: select lower(replace(replace(name, ' ', ''), '\\\'', '')) from business; Thanks ... Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Y

[SQL] Question about insert/update RULEs.

Hello, I am trying to use the RULE system to simulate updatable views, with the final goal of simulating polymorphism in an ORM-like system (Class::DBI). Same old idea - when selecting from foo C:DBI checks the "type" column and reblesses (I guess casts, in non-perl world) the object to the appro

Re: [SQL] Calling a table residing in another database from Plpgsql

hi, [EMAIL PROTECTED] wrote, On 1/5/2005 06:13: I infact downloaded the dblink package in contrib folder. But still when i tried to use dblink in the following manner: SELECT * from dblink('host=192.168.0.50 dbname=AK1 user=akteam','Select userid from user_reg') as t (userid integer); I am getting

Re: [SQL] [JDBC] Calling a table in another database from plpgsql

Kris is correct, this is a jdbc list, however to satisfy your curiosity, you can't access data from another database. Dave [EMAIL PROTECTED] wrote: Hi, I have function called test1() in database 1. I need to input the value from this function into another table which is in database2. How can i ac