pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedPlease help me....
10+ messages / 7 participants
[nested] [flat]
* Please help me....
@ 2001-05-22 13:19 waheed rahman <waheed_rahuman@yahoo.com>
0 siblings, 0 replies; 10+ messages in thread
From: waheed rahman @ 2001-05-22 13:19 UTC (permalink / raw)
To: pgsql-admin@postgresql.org; pgsql-sql-owner@postgresql.org; pgsql-sql
Dear Sir,
I am waheed from dubai.
I got your mailid, when i am searching for a document
in postgresql.And your document helped me
alot and i some more doubts i hope you can help me.
This is my problem.
I am having a table called FRUITS which will be
updated by the merchants frequently as
the merchants got with them FRUITS.
At the same time my another web interface, have an
option for the public search to
the FRUITS.In this my educational project,if the
search result nothing
(query does not matches with the fruit detail).
I am having an option for the end user (ie) people who
searching for FRUITS can
register with their email ids and i will save their
specification of FRUITS(query for the
particular not avialable FRUIT).
So that when i got a new record in the table FRUITS,i
have to check for the query that i have
saved and if the query matches with new record added.I
have to send this FRUITS details to
that particular email id.
Please help me in this regard .I am expecting your
valuable reply.
How i can trigger email when the query matches.I am
using JSP for the complete web interface and
database is Postgres in my Red hat linux 7.0.I will be
thankfull for your valuable reply.
with warm regards and advance thankings from
waheed.
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Please Help me
@ 2002-08-01 06:49 Christopher Kings-Lynne <chriskl@familyhealth.com.au>
parent: Waheed Rahuman <waheed@digiba.com>
1 sibling, 1 reply; 10+ messages in thread
From: Christopher Kings-Lynne @ 2002-08-01 06:49 UTC (permalink / raw)
To: Waheed Rahuman <waheed@digiba.com>; pgsql-sql
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 may still choose to
use MySQL.
Postgres has these things that MySQL doesn't:
* SQL compatible date & time handling
* subselects
* stored procedures
* proper foreign keys
* proper transactions
* views
* custom types, aggregates, operators and functions
* 4 procedural languages
* ...and much, much more...
You haven't provided us with very much information, however...
Chris
-----Original Message-----
From: pgsql-sql-owner@postgresql.org
[mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Waheed Rahuman
Sent: Friday, 2 August 2002 1:11 AM
To: pgsql-sql@postgresql.org
Subject: [SQL] Please Help me
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
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Please Help me
@ 2002-08-01 14:16 Michelle Murrain <tech@murrain.net>
parent: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
0 siblings, 1 reply; 10+ messages in thread
From: Michelle Murrain @ 2002-08-01 14:16 UTC (permalink / raw)
To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>; Waheed Rahuman <waheed@digiba.com>; pgsql-sql
<!doctype html public "-//W3C//DTD W3 HTML//EN">
<html><head><style type="text/css"><!--
blockquote, dl, ul, ol, li { padding-top: 0 ; padding-bottom: 0 }
--></style><title>Re: [SQL] Please Help me</title></head><body>
<div>At 2:49 PM +0800 8/1/02, Christopher Kings-Lynne wrote:</div>
<blockquote type="cite" cite><font face="Arial" size="-1"
color="#0000FF">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.</font></blockquote>
<div><br></div>
<div>Yeah, except I do have experience with ColdFusion, and ColdFusion
runs into some very problematic issues with Postgres, sadly. Although
I use Postgres almost exclusively, I had to switch to MySQL for use
with ColdFusion.</div>
<x-sigsep><pre>--
</pre></x-sigsep>
<div>.Michelle<br>
<br>
--------------------------<br>
Michelle Murrain, Technology Consulting<br>
tech@murrain.net http://www.murrain.net<br;
413-253-2874 ph<br>
413-222-6350 cell<br>
413-825-0288 fax<br>
AIM:pearlbear0 Y!:pearlbear9 ICQ:129250575</div>
</body>
</html>
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Please Help me
@ 2002-08-01 14:32 Chad Thompson <chad@weblinkservices.com>
parent: Waheed Rahuman <waheed@digiba.com>
1 sibling, 1 reply; 10+ messages in thread
From: Chad Thompson @ 2002-08-01 14:32 UTC (permalink / raw)
To: Waheed Rahuman <waheed@digiba.com>; pgsql-sql
I am running RedHat, with Apache and Cold Fusion. I chose PostgreSQL for all of the aforementioned reasons. It works very well with Cold Fusion. I have done some optimizing and am able to run rather complex queries much faster than I ever was able to on any Windows platform database. I had to bail on MySQL because it wouldnt run the sub-queries that i needed.
Thanks
Chad
----- Original Message -----
From: Waheed Rahuman
To: pgsql-sql@postgresql.org
Sent: Thursday, August 01, 2002 11:10 AM
Subject: [SQL] Please Help me
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
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Please Help me
@ 2002-08-01 14:48 Michelle Murrain <tech@murrain.net>
parent: Chad Thompson <chad@weblinkservices.com>
0 siblings, 2 replies; 10+ messages in thread
From: Michelle Murrain @ 2002-08-01 14:48 UTC (permalink / raw)
To: Chad Thompson <chad@weblinkservices.com>; Waheed Rahuman <waheed@digiba.com>; pgsql-sql
<!doctype html public "-//W3C//DTD W3 HTML//EN">
<html><head><style type="text/css"><!--
blockquote, dl, ul, ol, li { padding-top: 0 ; padding-bottom: 0 }
--></style><title>Re: [SQL] Please Help me</title></head><body>
<div>At 8:32 AM -0600 8/1/02, Chad Thompson wrote:</div>
<blockquote type="cite" cite><font face="Arial" size="-1">I am running
RedHat, with Apache and Cold Fusion. I chose PostgreSQL for all
of the aforementioned reasons. It works very well with Cold
Fusion. I have done some optimizing and am able to run rather
complex queries much faster than I ever was able to on any Windows
platform database. I had to bail on MySQL because it wouldnt run
the sub-queries that i needed.</font></blockquote>
<div><br></div>
<div>How did you solve the problem of large text fields? We ran into
this problem, and was unable to solve it. We'd get an error if we
wanted to add more than, I think 200 or so characters. It had to do
with the connection between postgres and Cold Fusion.</div>
<x-sigsep><pre>--
</pre></x-sigsep>
<div>.Michelle<br>
<br>
--------------------------<br>
Michelle Murrain, Technology Consulting<br>
tech@murrain.net http://www.murrain.net<br;
413-253-2874 ph<br>
413-222-6350 cell<br>
413-825-0288 fax<br>
AIM:pearlbear0 Y!:pearlbear9 ICQ:129250575</div>
</body>
</html>
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Please Help me
@ 2002-08-01 14:56 Chad Thompson <chad@weblinkservices.com>
parent: Michelle Murrain <tech@murrain.net>
1 sibling, 0 replies; 10+ messages in thread
From: Chad Thompson @ 2002-08-01 14:56 UTC (permalink / raw)
To: pgsql-sql; Michelle Murrain <tech@murrain.net>
Re: [SQL] Please Help meUnfortunatly i know of no such problem. I have large text fields being submited to my database, but i restrict the submit page to 255 chars. I will have to test larger numbers and see what errors i get.
Thanks
Chad
----- Original Message -----
From: Michelle Murrain
To: Chad Thompson ; Waheed Rahuman ; pgsql-sql@postgresql.org
Sent: Thursday, August 01, 2002 8:48 AM
Subject: Re: [SQL] Please Help me
At 8:32 AM -0600 8/1/02, Chad Thompson wrote:
I am running RedHat, with Apache and Cold Fusion. I chose PostgreSQL for all of the aforementioned reasons. It works very well with Cold Fusion. I have done some optimizing and am able to run rather complex queries much faster than I ever was able to on any Windows platform database. I had to bail on MySQL because it wouldnt run the sub-queries that i needed.
How did you solve the problem of large text fields? We ran into this problem, and was unable to solve it. We'd get an error if we wanted to add more than, I think 200 or so characters. It had to do with the connection between postgres and Cold Fusion.
--
.Michelle
--------------------------
Michelle Murrain, Technology Consulting
tech@murrain.net http://www.murrain.net
413-253-2874 ph
413-222-6350 cell
413-825-0288 fax
AIM:pearlbear0 Y!:pearlbear9 ICQ:129250575
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Please Help me
@ 2002-08-01 15:16 Jochem van Dieten <nomail@devnull.invalid>
parent: Michelle Murrain <tech@murrain.net>
0 siblings, 0 replies; 10+ messages in thread
From: Jochem van Dieten @ 2002-08-01 15:16 UTC (permalink / raw)
To: pgsql-sql
Michelle Murrain wrote:
>
> Yeah, except I do have experience with ColdFusion, and ColdFusion
> runs into some very problematic issues with Postgres, sadly. Although
> I use Postgres almost exclusively, I had to switch to MySQL for use
> with ColdFusion.
I wonder what your issues are, because in my experience it is very
version related. With PostgreSQL versions before 7.1 there were various
problems. As of 7.1, the main problem has been drivers. ColdFusion came
with old (obsolete) drivers that didn't support many of the new features
in postgreSQL. A custom compilation of new drivers was required, but was
a tricky process.
As of CF MX, IMHO PostgreSQL is the clear winner. For the very simple
reason of full Unicode support, which means internationalization is a
breeze. Simply save templates as UTF-8 and create a database with
Unicode encoding and you are ready. And I am not aware of any problems
with the JDBC drivers.
Jochem
PS Whichever you choose, use cfqueryparam exclusively in your queries.
^ permalink raw reply [nested|flat] 10+ messages in thread
* Please Help me
@ 2002-08-01 17:10 Waheed Rahuman <waheed@digiba.com>
0 siblings, 2 replies; 10+ messages in thread
From: Waheed Rahuman @ 2002-08-01 17:10 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Please Help me
@ 2002-08-02 01:13 Christopher Kings-Lynne <chriskl@familyhealth.com.au>
parent: Michelle Murrain <tech@murrain.net>
1 sibling, 0 replies; 10+ messages in thread
From: Christopher Kings-Lynne @ 2002-08-02 01:13 UTC (permalink / raw)
To: Michelle Murrain <tech@murrain.net>; Chad Thompson <chad@weblinkservices.com>; Waheed Rahuman <waheed@digiba.com>; pgsql-sql
Re: [SQL] Please Help meMichelle,
Have you tried it with Postgres 7.1 yet, which removed such limitations?
Chris
-----Original Message-----
From: pgsql-sql-owner@postgresql.org
[mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Michelle Murrain
Sent: Thursday, 1 August 2002 10:48 PM
To: Chad Thompson; Waheed Rahuman; pgsql-sql@postgresql.org
Subject: Re: [SQL] Please Help me
At 8:32 AM -0600 8/1/02, Chad Thompson wrote:
I am running RedHat, with Apache and Cold Fusion. I chose PostgreSQL
for all of the aforementioned reasons. It works very well with Cold Fusion.
I have done some optimizing and am able to run rather complex queries much
faster than I ever was able to on any Windows platform database. I had to
bail on MySQL because it wouldnt run the sub-queries that i needed.
How did you solve the problem of large text fields? We ran into this
problem, and was unable to solve it. We'd get an error if we wanted to add
more than, I think 200 or so characters. It had to do with the connection
between postgres and Cold Fusion.
--
.Michelle
--------------------------
Michelle Murrain, Technology Consulting
tech@murrain.net http://www.murrain.net
413-253-2874 ph
413-222-6350 cell
413-825-0288 fax
AIM:pearlbear0 Y!:pearlbear9 ICQ:129250575
^ permalink raw reply [nested|flat] 10+ messages in thread
* please help me ???
@ 2003-05-30 05:02 andhie lala <andhie_sql@linuxmail.org>
0 siblings, 0 replies; 10+ messages in thread
From: andhie lala @ 2003-05-30 05:02 UTC (permalink / raw)
To: pgsql-sql
Dear All
I'am a new user in postgresql, i want to ask about :
1. The one who is intended with STORED PROCEDURE,
how its implement and what its surplus.
Version POSTGRESQL that how much possess STRORED PROCEDURE.
2. In when I make the function as follows:
CREATE FUNCTION forward(CHAR(10))
RETURNS CHAR(10), CHAR(30)
AS 'select no_id, name FROM address where no_id=$1;'
Language 'sql';
To step forward orders the error ...
Which wants I asked, how make a function that can step forward
RETURNS More than a column
(I want to show 2 columns i.e. no_id and Name) ?
thank's
--
______________________________________________
http://www.linuxmail.org/
Now with e-mail forwarding for only US$5.95/yr
Powered by Outblaze
^ permalink raw reply [nested|flat] 10+ messages in thread
end of thread, other threads:[~2003-05-30 05:02 UTC | newest]
Thread overview: 10+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-05-22 13:19 Please help me.... waheed rahman <waheed_rahuman@yahoo.com>
2002-08-01 17:10 Please Help me Waheed Rahuman <waheed@digiba.com>
2002-08-01 06:49 ` Re: Please Help me Christopher Kings-Lynne <chriskl@familyhealth.com.au>
2002-08-01 14:16 ` Re: Please Help me Michelle Murrain <tech@murrain.net>
2002-08-01 15:16 ` Re: Please Help me Jochem van Dieten <nomail@devnull.invalid>
2002-08-01 14:32 ` Re: Please Help me Chad Thompson <chad@weblinkservices.com>
2002-08-01 14:48 ` Re: Please Help me Michelle Murrain <tech@murrain.net>
2002-08-01 14:56 ` Re: Please Help me Chad Thompson <chad@weblinkservices.com>
2002-08-02 01:13 ` Re: Please Help me Christopher Kings-Lynne <chriskl@familyhealth.com.au>
2003-05-30 05:02 please help me ??? andhie lala <andhie_sql@linuxmail.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox