To create a Column ina Table with function - Mailing list pgsql-novice

From csanyipal@gmail.com
Subject To create a Column ina Table with function
Date
Msg-id 8761hnag9t.fsf@gmail.com
Whole thread Raw
Responses Re: To create a Column ina Table with function  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-novice
Hi,

I have a table with columns: number, date-range.
I wish to get in this table more columns: week-day-begin, week-day-end.

In the week-day-begin column I wish to get automatically the weekday
name of the first date in the date range.

In the week-day-end column I wish to get automatically the weekday
name of the last date in the date range.

How can I get these two columns by executing a function?
Should this function be a Dynamic Command, or a trigger?

Regards, from Pal

pgsql-novice by date:

Previous
From: Marc Richter
Date:
Subject: Re: Upgrading from PG 8.2.5 to 9.1.13
Next
From: Albe Laurenz
Date:
Subject: Re: To create a Column ina Table with function