agora inbox for postgres@postgres.berkeley.edu
help / color / mirror / Atom feedProblem using external SQL calls.
4+ messages / 4 participants
[nested] [flat]
* Problem using external SQL calls.
@ 1995-08-05 20:01 David S. Kenzik <dsk1@one.net>
0 siblings, 1 reply; 4+ messages in thread
From: David S. Kenzik @ 1995-08-05 20:01 UTC (permalink / raw)
To: legacy
I am using Postgre95 beta 0.02 along with PGperl5 in a Solaris 2.4
environment.
I have created a database called 'dbtest', set up a couple fields, and
entered 1 row of data.
Monitor output follows:
----------------------
bash$ monitor dbtest
Welcome to the POSTGRES95 terminal monitor
Go
* select * from person;
Query sent to backend is "select * from person;"
-----------------------------
| name | age |
-----------------------------
| dave | 10 |
-----------------------------
---------------------
I have a script written in perl 5 using PGpm that doesn't return any
value, except 'PGblank'. The code follows:
---------------------
#!/usr/bin/perl
use Pg;
$db="dbtest";
PQsetdb($db);
$query="select * from person";
$result=PQexec($query);
print "$result\n";
And the results:
bash$ ./dbtest2
Pblank
-----------------
Any insight would be greatly appreciated, as it's been a long couple of
days. :)
Regards,
.===========================================================================.
| David S. Kenzik - Project Director - OneNet Communications : dsk1@one.net |
+===========================================================================+
| Current Projects: finger projects@one.net WWW: http://www.one.net |
| Information: info@one.net Phone: (513) 326-6000 |
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
==============================================================================
To add/remove yourself to/from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
==============================================================================
URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Problem using external SQL calls.
@ 1995-08-06 01:22 Casey Claiborne <mskc@io.com>
0 siblings, 0 replies; 4+ messages in thread
From: Casey Claiborne @ 1995-08-06 01:22 UTC (permalink / raw)
To: David S. Kenzik <dsk1@one.net>; legacy
How were you able to use SQL statements. What version do you have?
I would always have to use something like "retrieve (person.all)" to get the
data
that you have.
I, myself, used a "C" interface and I was able to get data back that way. There
are examples (similar to the one you have below, except written in "C") in the
directory holding sample code.
Also, if I remember correctly, you can also check
"manual.ps" or "manual.txt" or one of these files that hold the references to
the types of commands that are available as a part of Postgres, there is an
area that discusses the "retrieve" command. There is also some "C" code that
goes with the explanation. That part helped me out a *whole* lot - there were
a lot of examples.
I know that you are using perl. I was just providing another option.
Good Luck :-)
Casey
At 04:01 PM 8/5/95, David S. Kenzik wrote:
>
>I am using Postgre95 beta 0.02 along with PGperl5 in a Solaris 2.4
>environment.
>
>I have created a database called 'dbtest', set up a couple fields, and
>entered 1 row of data.
>
>Monitor output follows:
>
>----------------------
>bash$ monitor dbtest
>Welcome to the POSTGRES95 terminal monitor
>
>Go
>* select * from person;
>
>Query sent to backend is "select * from person;"
>-----------------------------
>| name | age |
>-----------------------------
>| dave | 10 |
>-----------------------------
>
>---------------------
>
>I have a script written in perl 5 using PGpm that doesn't return any
>value, except 'PGblank'. The code follows:
>
>---------------------
>
>#!/usr/bin/perl
>use Pg;
>$db="dbtest";
>PQsetdb($db);
>$query="select * from person";
>$result=PQexec($query);
>print "$result\n";
>
>And the results:
>
>bash$ ./dbtest2
>Pblank
>
>-----------------
>
>Any insight would be greatly appreciated, as it's been a long couple of
>days. :)
>
>
>Regards,
>
>.===========================================================================.
>| David S. Kenzik - Project Director - OneNet Communications : dsk1@one.net |
>+===========================================================================+
>| Current Projects: finger projects@one.net WWW: http://www.one.net |
>| Information: info@one.net Phone: (513) 326-6000 |
>=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
>
>
>==============================================================================
> To add/remove yourself to/from the POSTGRES mailing list: send mail with
> the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
> If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
> a human will deal with it. DO NOT post to the "postgres" mailing list.
>==============================================================================
> URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/
>
>
Casey Claiborne mskc@io.com
One must note the importance of setting reasonable and achievable goals for
"If you aim for nothing, you'll hit it every time"
-Theodore Roosevelt
==============================================================================
To add/remove yourself to/from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
==============================================================================
URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Problem using external SQL calls.
@ 1995-08-06 03:51 Andrew K. Yu <andrew@postgres.Berkeley.EDU>
0 siblings, 0 replies; 4+ messages in thread
From: Andrew K. Yu @ 1995-08-06 03:51 UTC (permalink / raw)
To: mskc@io.com; +Cc: legacy
> How were you able to use SQL statements. What version do you have?
>
> At 04:01 PM 8/5/95, David S. Kenzik wrote:
> >
> >I am using Postgre95 beta 0.02 along with PGperl5 in a Solaris 2.4
> >environment.
Postgres95 uses SQL instead of POSTQUEL. It's in the last phase of its beta
cycle. More info can be obtained from
http://s2k-ftp.cs.berkeley.edu:8000/postgres95
Just like POSTGRES, it is unsupported software.
We have a separate mailing list (which has well over 200 subscribers) to
discuss matters related to postgres95.
I must apologize to the POSTGRES audience for having to say this repeatedly.
We do not discuss postgres95 on the POSTGRES mailing list and I will not
answer any questions about postgres95 posted to this list.
-andrew
==============================================================================
To add/remove yourself to/from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
==============================================================================
URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Problem using external SQL calls.
@ 1995-08-06 03:51 Jolly Chen <jolly@postgres.Berkeley.EDU>
parent: David S. Kenzik <dsk1@one.net>
0 siblings, 0 replies; 4+ messages in thread
From: Jolly Chen @ 1995-08-06 03:51 UTC (permalink / raw)
To: David S. Kenzik <dsk1@one.net>; +Cc: legacy
Please send all postgres95 related mail to the
postgres95@postgres.berkeley.edu list, not postgres@postgres.berkeley.edu.
For those of you on the postgres list who don't know what postgres95 is
all about, check out our home page at:
http://s2k-ftp.cs.berkeley.edu:8000/postgres95
- Jolly
==============================================================================
To add/remove yourself to/from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
==============================================================================
URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~1995-08-06 03:51 UTC | newest]
Thread overview: 4+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1995-08-05 20:01 Problem using external SQL calls. David S. Kenzik <dsk1@one.net>
1995-08-06 03:51 ` Jolly Chen <jolly@postgres.Berkeley.EDU>
1995-08-06 01:22 Re: Problem using external SQL calls. Casey Claiborne <mskc@io.com>
1995-08-06 03:51 Re: Problem using external SQL calls. Andrew K. Yu <andrew@postgres.Berkeley.EDU>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox