Hi, Marc,
Hi, Tom,
Tom Lane wrote:
> "Marc G. Fournier" <[EMAIL PROTECTED]> writes:
>> More then one Record:
>> # select get_next_billing_date(activated, 12) from company_details;
>> ERROR: control reached end of function without RETURN
>> CONTEXT: PL/pgSQL function "get_next_billing_date"
>
>
CREATE TABLE admin_activity
(
activity_id int4 NOT NULL,
Activity_name varchar NOT NULL,
URL varchar,
parent_activity_id int4);
1
Administration
0
2
Activities
1
3
Manage
Activity
2
4 Map
On Wed, Oct 11, 2006 at 21:31:37 +0200,
Daniel Drotos <[EMAIL PROTECTED]> wrote:
> On Wed, 11 Oct 2006, Markus Schaber wrote:
>
> After inserting new rows into this table, very old rows are going to
> be deleted. But value of deleted info should be remembered somehow, so
> there is a trigger o
Thanks Tom that's great!!
When I first saw your solution I thought it was logically going to do
(notice the parentheses):
select ('2006-07-13 09:20:00'::timestamp) at time zone 'EST5EDT';
which does not help
So I was not hopeful, but when I tried it it did exactly what I needed which
is:
