Hi,
i would like to check for a given query (insert, update, delete) if
there is a key or constraint violation which prevents the query from
being executed.
Is such a feature implemented in the perl or java drivers?
If so, could anyone point to a list of available return codes?
Thanks
Alex
-
Will there be a release 7.4.7 in the future?
When can the production release of 8 be expected?
thanks
Alex
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not matc
Hi,
when creating a query with a subselect
SELECT name, (SELECT max(pop) FROM cities WHERE cities.state = states.name) AS max_pop
FROM states;
then it is not possible to sort after max_pop or use max_pop in a function or a CASE.
am I dont anything wrong or is this meant to be the case?
Thanks
Al
Hi,
I have a problem I dont really know how to solve except for writing a
function.
I have a table with prices;
SecCode| Price | PriceDate
---++---
A0001 | 13.10 | 2004-10-30
A0001 | 13.03 | 2004-10-29
A0001 | 13.12 | 2004-10-28
A0001 | 12.45 | 2004-10-27
A0001
It depends of data type - unfortunately max was not defined for ALL
appropriate types. Through
testo=> select max(bypref) from inetspec;
max
---
24
where bypref is int2.
On Sat, 6 Feb 1999, dustin sallings wrote:
> Date: Sat, 6 Feb 1999 13:10:56 -0800 (PST)
> From: dustin sallings <[EMAIL
Looks like you are running two PSQL server with THE SAME DATA BASE
DIRECTORY!
On Thu, 21 Jan 1999, Jeff Hoffmann wrote:
> Date: Thu, 21 Jan 1999 08:46:56 -0600
> From: Jeff Hoffmann <[EMAIL PROTECTED]>
> To: David Giffin <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED]
> Subject: Re: [GENERAL] Mu
Hmm.
Due to my experience (I have played with boths) - if you need stable
network with predicted behaviour in case of disc overflow, bad (crazy)
requests, and you lost a lot of money in case of any instability - use
Oracle. If you need to deploy wide informational system, it should be
easy to
Btw, I have wrote some kind of GUI (look at http://noc.bn.ru:8100/DEMO,
you can CREATE TYPE (type == table, there was not SQL but object editor),
edit list of objects etc etc /there is ip data base used as demo data
base/), I have found GUI about 1/2 year ago and did not get great
success.
Th
