Re: [ADMIN] query and stored procedures

2005-01-05 Thread Joshua D. Drake
David Bear wrote: I'm so totally new to postgresql that I'm not sure how to word this. What you want to do is create a function (store procedure)... You can use plpythonu to do what you want. So you could create something like this: create or replace function check_id(text) returns integer as ..

Re: [ADMIN] query and stored procedures

2005-01-05 Thread Uwe C. Schroeder
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Well, I'd use pgsql - as a quick idea you could use something like: CREATE OR REPLACE FUNCTION checkssn(varchar) RETURNS SETOF whatever_your_table AS ' DECLARE incoming_ssn ALIAS FOR $1; result whatever_your_table%ROWTYPE; my_

Re: [ADMIN] postgresql 7.4.6 and pam_ldap

2005-01-05 Thread Gémes Géza
Thomas Leduc írta: Hi, I know that i'm not the 1st one who want's to use pam_ldap to authenticate users (55 posts with keywords ldap and pam...). But it also didn't work for me. Please, what's wrong with the following: % pg_config --configure '--host=i386-redhat-linux' '--build=i386-redhat-linux' [

[ADMIN] query and stored procedures

2005-01-05 Thread David Bear
I'm so totally new to postgresql that I'm not sure how to word this. I want to create a query, that does two things 1) take input in the form of a string of numbers, and test if a) is ssn b) or internal id if the string is an ssn, make a second query to another data base, asking it to conve

[ADMIN] Nullable columns and views

2005-01-05 Thread Bradley Kieser
I have created a schema with views on top of tables. We use JDBC to connect to the schema and we use JBuilderX to develop our app. Every table as an "id" column of type serial. I.e. It is not null with default nextval(...). However, it seems that when a column from a table is used in a view, the

[ADMIN] postgresql 7.4.6 and pam_ldap

2005-01-05 Thread Thomas Leduc
Hi, I know that i'm not the 1st one who want's to use pam_ldap to authenticate users (55 posts with keywords ldap and pam...). But it also didn't work for me. Please, what's wrong with the following: % pg_config --configure '--host=i386-redhat-linux' '--build=i386-redhat-linux' [...] '--with-opens