On 11/7/06, Peter Michaux [EMAIL PROTECTED] wrote:
I would like to learn how to write a simple SQL parser and database
program ... Is there a link or book that explains the basics of how a
database parses SQL and how it then operates on the data?
For a fairly good learning resource, you can
On 11/6/06, Hubert Retif [EMAIL PROTECTED] wrote:
I am migrating my application from MySQL to
Postgresql and have met following situation:
SELECT
(sum(sold_price)/(select sum(sold_price) from
car_archive))*100 as CA_pcent,
reason_text
FROM car_archive
group by reason_text
order by CA_pcent
On Mon, 2006-11-06 at 05:08, Hubert Retif wrote:
Hi,
I am migrating my application from MySQL to Postgresql and have met
following situation:
SELECT
(sum(sold_price)/(select sum(sold_price) from car_archive))*100 as
CA_pcent,
reason_text
FROM car_archive
group by reason_text
On Fri, 3 Nov 2006, Tom Lane wrote:
Well, I can't find anything wrong :-(. There are some differences in
the list of contained keys, but they're all up near the end of the
range, which is consistent with the assumption that the table is live
and had some changes between your two dumps of the
--- [EMAIL PROTECTED] wrote:
Hi all,
I have been working on this Informix SQL query which has an outer
join.
I have attached Informix query and my supposedly solution to this
query
but I cannot get the same count. I appreciate for any help.
Thanks.
--Informix query
select
Moving to -general (and please start a new thread instead of hijacking
an existing one).
On Thu, Nov 02, 2006 at 01:14:22PM -0500, louis gonzales wrote:
Hello all,
Is there an existing mechanism is postgresql that can automatically
increment/decrement on a daily basis w/out user interaction?
