[GENERAL] Per session variables

Hi guys, I've googled about a bit, and found some ideas for solving this problem, but I thought I'd pose the question, in the hope that someone can suggest something. I've got a web application that needs to do audit logging, taking some information provided by the webapp such as user, reque

Re: [GENERAL] ALTERING A TABLE

--snip-- Or is that CAST it on the wasy. Richard

Re: [GENERAL] PostgreSQL book completed though chapter 10

Bruce Momjian wrote: > > I have completed the first draft of my book through chapter 10. > > New chapters include: > > Chapter 7, Numbering rows: OID's, sequences > > Chapter 8, Combining Selects: UNION, subqueries > > Chapter 9, Data Types: types, functions, operat

[GENERAL] beginner Table data type question

Hi, I just start using pgsql and I am new to SQL also. I have read lots of documents on this and I cant seem to find the answer, perhaps you can help me. Say I have a table: pgsql=> \d test_table test_table -- f1| CHAR (40) f2| CHAR (40) Somewhere down the line I n

[GENERAL] INSERT WITH SELECT help

I am new to SQL so bare with me here. I have set up a contact database. The PRIMANY KEY is person.per_id All the other tables REFERENCE the person.per_id key. Now I want to be able to INSERT INTO the address table based on person.per_id by name without having to know the value of person.per_id

Re: [GENERAL] INSERT WITH SELECT help

--snip-- Yes, I like the Idea of picking from a list if you get a return > 1. off topic: The main point of this whole little project was to design a SQL database and make a Web interface to it. One of my main goals was to learn the how and why's of SQL. My Zope skill are sub par also, so