Hi fellows!
I'm interested in programming a first prototype to demonstrate
3-tier programming using PostGRE database.
Windows Linux RH
Linux RH
+-+ ++
++
| Java |
On Wed, 31 Jul 2002, Elielson Fontanezi wrote:
Well since you are already using good free software (pgsql)
you should probably consider jboss.
Not much fancy GUI staff, but serious J2EE work.
You can easily run a postgres service inside jboss.
>
> I would like to know which application s
I have two similar tables with host and services availability
data (Nagios). And I want to find out services which are not OK
in first table and OK in second one. Query I used is:
select c.* from coll_servicestatus as c inner join
servicestatus as s on (c.service_description=s.service_descript
On Wed, 31 Jul 2002, Mindaugas Riauba wrote:
>
> I have two similar tables with host and services availability
> data (Nagios). And I want to find out services which are not OK
> in first table and OK in second one. Query I used is:
>
> select c.* from coll_servicestatus as c inner join
> serv
hi all,
here's a query i've never been able to improve:
i have an old data set and a new data set - in this case uk postcodes
with eastings and northings. i want to extract the new and changed
postcodes from the new set. to get the changed entries i use a join and
it works okay:
SELECT n.post
On 31 Jul 2002, Jinn Koriech wrote:
> hi all,
>
> here's a query i've never been able to improve:
>
> i have an old data set and a new data set - in this case uk postcodes
> with eastings and northings. i want to extract the new and changed
> postcodes from the new set. to get the changed entr
Hi Folks,
Pretty basic one here. I'm trying to do a SELECT statement that includes a
CASE structure that will be used in the ORDER BY clause, and I want the CASE
structure to evaluate a bunch of criteria and in each case increment its
value by a certain amount:
SELECT id, description CASE
On Wed, 31 Jul 2002, Tom Haddon wrote:
> Hi Folks,
>
> Pretty basic one here. I'm trying to do a SELECT statement that includes a
> CASE structure that will be used in the ORDER BY clause, and I want the CASE
> structure to evaluate a bunch of criteria and in each case increment its
> value by a
Hi Stephan,
I have a lot of fields, so I'm not sure if a function or case is the way to
go. Basically, I have, say 50 boolean fields that are being evaluated, and I
want to have a column which is the sum of the number of "TRUE" values of
those 50 columns, and then ORDER BY that column. So, for ex
Just 'cuz you can do something with a language feature does not
necessarily mean that it is a good way to do it. If this is a
common query and you have a large dataset, then this is going to
be computationally intensive.
Why not create a field as part of the table and create a trigger
to update
On Wed, 31 Jul 2002, Tom Haddon wrote:
> Hi Stephan,
>
> I have a lot of fields, so I'm not sure if a function or case is the way to
> go. Basically, I have, say 50 boolean fields that are being evaluated, and I
> want to have a column which is the sum of the number of "TRUE" values of
> those 5
> but then to get the entirely new items out i use a sub query which takes
> for ever
>
> SELECT DISTINCT * FROM v_postcode_new WHERE postcode NOT IN ( SELECT
> postcode FROM v_postcode_old ) ORDER BY postcode ASC;
NOT IN is known to be very, very slow in Postgres. Use NOT EXISTS instead:
SELEC
--- Jinn Koriech <[EMAIL PROTECTED]> wrote:
> hi all,
> but then to get the entirely new items out i use a
> sub query which takes
> for ever
>
> SELECT DISTINCT * FROM v_postcode_new WHERE postcode
> NOT IN ( SELECT
> postcode FROM v_postcode_old ) ORDER BY postcode
> ASC;
>
> does anyone know
Dear all
Please suggest me which database i can choose for
my server setup like
1. Manrake Linux
2. ColdFusion
3. Apache Webserver
Now i dont know which database to
choose
Whether MySQL or PostgreSQL
Please suggest me a.
Thank you
Expecting your reply
Regards
Waheed Rahuman
Postgres is totally, absolutely free. It comes under the terms of
the BSD license which means you have the right to use and modify the source code
in any way you wish, so long as you acknowledge that the code originated in
Postgres. It is even more free than MySQL.
Chris
-Original
I have
no experience with ColdFusion, but if you ask a question like whether MySQL or
Postgres is better on a Postgres mailing list - we're going to say
Postgres.
Postgres is in many, many ways vastly superior to MySQL. However,
if you are a newbie or are doing this on Win32 platform, you
Hello
Can anyone say about license of
postgresql database
How much it cost around.
Thanks in advance
waheed
17 matches
Mail list logo
