[SQL] PL/pgSQL

2000-05-27 Thread Antony Sakellariou
I m using postgresql under linux suse 6.3. I have installed the language as the documentation indicates by creating the call handler and the language. Trying to create a function within a database the psql interface is replying that the function is created. But when I call the function ( it ret

Re: [SQL] joins again

2000-05-27 Thread Erol Oz
Hi, You may find examples in the section 'Joining Tables' of Bruce Momjian's marvelous work. http://www.postgresql.org/docs/aw_pgsql_book/node63.html I hope this helps. Regards Erol CB wrote: > Hi, > > Can someone tell me which (if any) joins are supported with 7? It > appears the answer is 'n

[SQL] joins again

2000-05-27 Thread CB
Hi, Can someone tell me which (if any) joins are supported with 7? It appears the answer is 'none' but I want to make sure. Since I think the answer is 'none' can someone tell me how you emulate inner and outer joins using the where clause (I need an example)? Thanks! Craig

Re: [SQL] New Type

2000-05-27 Thread selkovjr
> Hi all, > > I'm trying to create a type password; the goal is to have a table like: > > CREATE TABLE test ( > username varchar, > pass passwd); > > insert into test values ('me','secret'); > > and have "secret" being automagicly crypted. > > What I want is to mimic the PASSWORD function of