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 c
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_pce
On 11/1/06, Raghuraman K <[EMAIL PROTECTED]> wrote:
Hi,
I have a table like this: create
table(xyz char(10), answer number(4)). There are a lot of rows in this
table. I am looking at a query that will help me represent the distribution of
data records based on the column answer. For example,
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
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 in
> --- [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
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