Hello,
I am trying to store images (bin files) from delphi (ADO components) to
postgresql, I found data type bytea for that, but I could not make it
work. May be anyone has sample of delphi code? or can give any help with it?
thx
Lukas
--
This message has been scanned for viruses and
Frank Bax wrote:
At 09:00 AM 10/12/05, Daryl Richter wrote:
Richard Huxton wrote:
Frank Bax wrote:
[snip]
Richard, you've summed it up nicely.
Splitting locations into subsets (like 2,2,3) doesn't work because it is
possible that low values in one location can be offset by high
Hi
CREATE TRIGGER associates trigger function on a table and it is not possible to give more than one table seperated by comas.
CREATE TRIGGER emp_cust_stamp BEFORE INSERT OR UPDATE ON customersFOR EACH ROW EXECUTE PROCEDURE last_updated_stamp();
CREATE TRIGGER emp_cust_stamp BEFORE INSERT OR
On Thu, Oct 13, 2005 at 12:24:55AM -0400, Greg Stark wrote:
Well the constants and the like are precisely the point. There
are plenty of cases where adding the column to the GROUP BY is
unnecessary and since Postgres makes no attempt to prune them out,
inefficient.
But inefficient pruning is
On Wed, Oct 12, 2005 at 10:52:04PM -0400, Tom Lane wrote:
the documentation of the core system shouldn't rely on them ... but
that leaves us presenting C-code triggers as the only examples in
chapter 35. There is a paragraph in there suggesting you go look at
the PL languages first, but
On Wed, 2005-10-12 at 20:13, Greg Stark wrote:
Scott Marlowe [EMAIL PROTECTED] writes:
Hehe. When I turn on my windshield wipers and my airbag deploys, is it
a documented feature if the dealership told me about this behaviour
ahead of time?
Well it's more like my car where the
What indexes do you have on these tables?And have you ANALYZEd all three recently? --Thomas F. O'ConnellCo-Founder, Information ArchitectSitening, LLCOpen Source Solutions. Optimized Web Development.http://www.sitening.com/110 30th Avenue North, Suite 6Nashville, TN
On Wed, Oct 12, 2005 at 10:52:04PM -0400, Tom Lane wrote:
Jeff Williams [EMAIL PROTECTED] writes:
Thanks. Triggers was my first thought, but chapter 35 on Triggers didn't
really indicate a way I could do this easily and scared me with a lot of
c code.
Yeah. This is a documentation issue
Is a working example something that people would like to see? Or is this
considered a good use of research time?
On Thursday 13 October 2005 11:20 am, Jim C. Nasby wrote:
On Wed, Oct 12, 2005 at 10:52:04PM -0400, Tom Lane wrote:
Jeff Williams [EMAIL PROTECTED] writes:
Thanks. Triggers was
Scott Marlowe [EMAIL PROTECTED] writes:
Sorry, but it's worse than that. It is quite possible that two people
could run this query at the same time and get different data from the
same set and the same point in time. That shouldn't happen accidentally
in SQL, you should know it's coming.
Indexes are on all join fields. In the shown
example on all fields I have indexes.
Yes I vacuum the database regulary.
Andy.
- Original Message -
From:
Thomas F.
O'Connell
To: Andy
Cc: pgsql-sql@postgresql.org
Sent: Thursday, October 13, 2005 7:58
PM
On Thu, 2005-10-13 at 13:26, Greg Stark wrote:
Scott Marlowe [EMAIL PROTECTED] writes:
Sorry, but it's worse than that. It is quite possible that two people
could run this query at the same time and get different data from the
same set and the same point in time. That shouldn't happen
On Thu, Oct 13, 2005 at 02:26:58PM -0400, Greg Stark wrote:
Scott Marlowe [EMAIL PROTECTED] writes:
could run this query at the same time and get different data from the
same set and the same point in time.
I'm pretty unsympathetic to the we should make a language less powerful and
more
Greg,
You would prefer:
select user_id,
any(username) as username, any(firstname) as firstname,
any(lastname) as lastname, any(address) as address,
any(city) as city, any(street) as street, any(phone) as phone,
any(last_update) as last_update, any(last_login) as
In standard SQL you have to
write GROUP BY ... and list every single column you need from the master
table.
This thread seems to have gone off on a tangent that depends on the
assumption that the above is a correct statement. It's not. It *was*
true, in SQL92, but SQL99 lets you omit
Well...
An additional gripe is that this isn't a good feature (standard or not).
Oracle doesn't do it. Db2 doesn't do it. I strongly suggest you guys
don't
do it.
If you wanna do the optimizations under the covers, cool, but I can't
imagine how this would be useful other than for saving some
Anthony Molinaro [EMAIL PROTECTED] writes:
An additional gripe is that this isn't a good feature (standard or not).
Oracle doesn't do it. Db2 doesn't do it.
You sure about that? It's hard to believe that the SQL committee would
put a feature into the spec that neither Oracle nor IBM intended
Tom,
I'm sure there's all sorts of cool optimizations under the covers
to perhaps maybe to this short circuiting,
but as the sql goes, yeah, I'm sure.
Here's an example on oracle 10g release 2 (copy paste from my screen so
you can see the error messages and all):
SQL create table
18 matches
Mail list logo
