Re: [GENERAL] using result as part of regular expression

larry a price writes: > SELECT table1.name,table2.web,table2.email > WHERE table1.name LIKE upper(table2.name).'%'; > ^^ trying for > 'content%' || is the operator for string concatenation. -- Peter Eisentraut

[GENERAL] Locks in functions

I have been reading in the dox that pgsql does not support cursors from inside any of the interfaces, well the ones I care about anyways which are PL and SPI... I'm using SPI to spawn an external process to run... (image manipulator), and I want to be able to control concurrent executions o

[GENERAL] Address already in use?

Hi Everyone, Alright, I've installed PostgreSQL 7.0.3 succesfully, but I still have a problem. When I try starting the PostgreSQL server, using the following command: /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data I get the following error: FATAL: StreamServerPort: bind() failed: Add

Re: [GENERAL] function to operate on same fields, different records?

On Mon, Apr 02, 2001 at 02:02:51PM -0500, will trillich wrote: > On Mon, Apr 02, 2001 at 10:21:34AM -0400, Tom Lane wrote: > > Inheritance seems to work for this in current sources: > > > > regression=# create table p1 (f1 int); > > CREATE > > regression=# create table p2 (f2 int) inherits (p1);