[SQL] distinct date problem

Hi, I'm having difficulty figuring this one out: I have a table with record entries which all have a date attribute, looking something like '2000-11-11'. What I want from my data base is a list of all the years that are present in this attribute in the relation. So for example, if I had a cou

[SQL] Using a messaging service....

Hello, I'm trying to use a java messaging service so I can post a message whenever my table has an update. Java API ^ | | Trigger update Java messagging

Re: [SQL] sum(bool)?

Olaf Marc Zanger wrote: >hi there, > >i want to add up the "true" values of a comparison like > >sum(a>b) > >it just doesn't work like this > >any workaround? select count(*) where a > b; -- Oliver Elphick[EMAIL PROTECTED] Isle of Wight

Re: [SQL] distinct date problem

This should work: SELECT distinct(date_part('year', )) FROM <>; Michael Fork - CCNA - MCP - A+ Network Support - Toledo Internet Access - Toledo Ohio On Sun, 25 Feb 2001, Lotus118 wrote: > Hi, > I'm having difficulty figuring this one out: > I have a table with record entries which all have a

[SQL] Function to return recordset

Hi, I need help! How can I get either sql or plpgsql function to return recordset? Thanks, Qiqi

Re: [SQL] Function to return recordset

From: "Qiqi Dong" <[EMAIL PROTECTED]> > Hi, > > I need help! How can I get either sql or plpgsql function to return > recordset? > > Thanks, > Qiqi If you have a table foo you can define your function with "returns foo" but you cannot use this like: select foo_function('x'); At present it is o

Re: [SQL] conversion

It looks like you have some rows for pyear which do not convert cleanly into a number like ' '. What do you want it to do in such cases? On Sun, 25 Feb 2001, Ken Kline wrote: > follow up > actually the destination column is defined > as a numeric(4) > > the following are the statements

Re: [SQL] Function to return recordset

It would be nice to have this feature in next release. I cannot port my applications to PostgreSQL without it. All my data objects depend on recordset returned from stored procedures. Could someone consider it for 7.1? Thanks. - Original Message - From: "Richard Huxton" <[EMAIL PROTECTED

Re: [SQL] conversion

here you go, thanks in advance, ken Table "temp" Attribute |Type | Modifier ---+-+-- pseason | varchar(15) | pyear | varchar(5) | adx=# \d pledge+ _classe4s  s Table "pledge_classes" Attribute | Type

[SQL] Urgent help

Tom, I think one of system file has been crupted. I tried to drop some user then db is hangged there forever, so kill that session, when I relogin and type urldb=# \z categories NOTICE: get_groname: group 2 not found The connection to the server was lost. Attempting reset: Failed. !# and new

[SQL] sysfile cruptted?

Tom, I even cannot drop a user also, urldb=# drop user sarah; ERROR: DROP USER: group "manager" does not exist urldb=# urldb=# select * from pg_group; groname | grosysid | grolist -+--+ manager |

Re: [SQL] Urgent help

another weired thing is, when I: select * from pg_group; it takes about 2 minites to return, it took just a tick before, it seems that some sys tables has been locked for a timeout. Thanks. Jie LIANG St. Bernard Software Internet Products Inc. 10350 Science Center Drive Suite 100, San Die

[SQL] DLookup('field', 'table', ['condition'])

Hi, I'm trying to create Domain Aggregate function that mimic Access' Dlookup function, but without any luck, after digging (i think) all the docs don't have the solution yet. Syntax: DLookup ('field', 'table|view', ['condition']) where: field -- column n

Re: [SQL] DLookup('field', 'table', ['condition'])

On Tue, 27 Feb 2001, Herbert Ambos wrote: > I'm trying to create Domain Aggregate function that mimic Access' Dlookup > function, but without any luck, after digging (i think) all the docs > don't have the solution yet. > > Syntax: > > DLookup ('field', 'table|view', ['condition']) > >