select group,rd_pk
from (select ...) as your_query,
(select max(run) as max_run,rd_pk as rd
from (select ...) as your_query) as max_rd
where rd = rd_pk
and max_run = run;
I dont know if you call that one query but it should work.
There may be more elegant solutions, but I havn't had a chance to r
On Wed, Dec 10, 2003 at 15:37:10 -0500,
Jodi Kanter <[EMAIL PROTECTED]> wrote:
> I have a query that produces results similar to this:
>
> run# rd_pk group#
> 09209 5
> 19209 8
> 09520 2
> 19520 5
> 09520
I have a query that produces results similar to this:
run# rd_pk group#
0 9209 5
1 9209 8
0 9520 2
1 9520 5
0 9520 etc
0 8652
1 8652
2 8652
0 8895
1
Chris Travers <[EMAIL PROTECTED]> writes:
> I have a function which moves a table from one schema to another by
> updating the relnamespace field of pg_class:
> Am I missing anything?
pg_constraint entries related to the table.
Also you need to
"sqllist" <[EMAIL PROTECTED]> writes:
> WHERE date < to_date( to_char(current_date,'-MM') || '-01','-mm-dd')
That seems like the hard way. Try this:
regression=# select date_trunc('month', now());
date_trunc
2003-12-01 00:00:00-05
(1 row)
Jeff,
We use a simple function that can be called in any query, like so:
SELECT * FROM table WHERE column < first_of_month();
-- Function: public.first_of_month()
CREATE FUNCTION public.first_of_month() RETURNS date AS '
DECLARE stamp DATE;
BEGIN
SELECT INTO stamp CAST(date_trunc(''month'',now())
Hi all;
I have a function which moves a table from one schema to another by
updating the relnamespace field of pg_class:
CREATE OR REPLACE FUNCTION move_relation(VARCHAR, VARCHAR, VARCHAR)
RETURNS BOOL
AS '
-- $1 is the table name
-- $2 is the source schema
-- $3 is the destination schema
--
Sorry for this misplaced question.
Olivier Hubaut wrote:
[snip]
--
Ci-git une signature avortee.
** RIP **
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
I'm trying to do a create function using JDBC 3,0 in Eclipse IDE with JFaceDBC plugin.
This function doesn't work:
CREATE FUNCTION @[EMAIL PROTECTED]@[EMAIL PROTECTED] ()
RETURNS boolean
LANGUAGE SQL
AS '
ALTER TABLE @[EMAIL PROTECTED]@[EMAIL PROTECTED]
