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
dangero
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 values
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 INSER
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 pruni
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 wh
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 37203-6320615-469-5150615-469-51
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 documenta
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. Trigg
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 comi
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
Subj
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
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 a
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 l
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 o
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 typ
"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 inten
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 foo
HelloI have 2
postgreSQL databases called "DATA1" and "DATA2" with several tables inside them
(table A, B, C). I modify the details in table "A" in database "DATA1"
How can I copy table "A" from database "DATA1" and paste it in database
"DATA2" using the same table name ??Thank you.
19 matches
Mail list logo
