Can you add two columns to the table creation definition, one with a
default current timestamp, the second to be updated with current time in
an on update trigger. Then perhaps you could do something like
SELECT
min(new_insert_timestamp_column),
max(new_update_timestamp_column) FROM your_table
> How to Create auto_increment field in PostreSQL.
Its called the SERIAL datatype:
create table test_table (
field1 serial,
constraint test_table_pkey primary key (field1));
> Can I create them using Trigger.
Yes, alternatively, but I'm told that is not recommended because the
server source c
>
>> Is there a way to automate the backup databases using pg_dump (like
>> in SQL server)?
>
Ha! Why would you want to do ANYTHING "like in SQL server"! ;)
You can do you back-ups very nicely using cron and a bash script:
bash-2.05a$ crontab -l
# DO NOT EDIT THIS FILE - edit the master and rein
>> What I need to know is whether or not this is multi-user safe, i.e.,
>> will the block of code in the procedure execute as a transaction so
>> that if more than one clerk creates an expense report for the same
>> employee simultaneously is it possible or impossible that value of
>> the
>> employ
I need to "manually" keep a sequence for each row of the employee table,
i.e., I don't want to use postgres's built-in sequences for this
application because the sequence numbers are used to generate expense
report numbers on a "per-employee" basis. That is, each employee has a
separate sequence co
> Dnia 2003-06-19 19:50, U¿ytkownik murali napisa³:
> > I' would like to connect my postgres database on a linux server with
> Delphi 5 Applications,which are located on Win95/98 Clients, very
> helpful would be an example on how to realize a connection of these
> things
>
> http://sourceforge.net
> Dnia 2003-06-27 12:25, U¿ytkownik [EMAIL PROTECTED] napisa³:
>
>> I think I looked at zeos at some point and found that it did not
>> support md5 authentication, which, at the time, I thought was
>> important.
>> ~Berend Tober
> Zeos has nothing to authentication. It's a matter of libpq library
> Am Sonntag, 22. Juni 2003 14:45 schrieb [EMAIL PROTECTED]:
>> I have not used column check constraints before, but I'd like to
>> start using then and so would I'll like to know if there is a direct
>> way to provide feedback to the end user about data validation rules
>> expressed in column che
I have not used column check constraints before, but I'd like to start
using then and so would I'll like to know if there is a direct way to
provide feedback to the end user about data validation rules expressed in
column check constraints?
For instance, say that I wanted to use a RE to check e-ma
