Re: [SQL] Secure DB Systems - How to

In the last exciting episode, [EMAIL PROTECTED] (Rajesh Kumar Mallah) wrote: > Sarah Tanembaum wrote: > >>I was wondering if it is possible to create a secure database system >>usingPostgreSQL/PHP combination? >> >>I have the following in mind: >> >>I wanted to store all my( and my brothers and sis

[SQL] calling function , passing OLD as argument

Hello. I am a beginner with pgsql and struggeling with the documentation. With the help from the folks on the PSQL Novice List I managed to work out that declaring CREATE OR REPLACE FUNCTION deny_namen_telefonverweise(namen_telefonverweise) RETURNS void AS ' DECLARE ... would work where the fu

[SQL] Indexable (constant LIKE prefix_keyfield) ?

I was impressed that LIKE operator can be indexed in 7.4 with non-C locale. But how about the reverse condition? What I need is to: SELECT * FROM prefixes WHERE 'literal' LIKE prefix || '%'; or SELECT * FROM prefixes WHERE 'literal' ~ ('^' || prefix); Prefix is of type text (variable-length), whi