--
Reuben D. Budiardja
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Saturday 19 February 2005 12:38, Robby Russell wrote:
> On Sat, 2005-02-19 at 10:02 -0500, Reuben D. Budiardja wrote:
> > Hello,
> > I mainly use PHP to access my database. The PHP in the server is compiled
> > with postgreSQL client lib v. 7.3. I am planning to upgrade m
a remote PostgreSQL server from a local PostgreSQL database.
Thank you in advance for any respond.
RDB
--
Reuben D. Budiardja
Dept. Physics and Astronomy
University of Tennesse, Knoxville, TN
-BEGIN GEEK CODE BLOCK-
Version: 3.12
GIT/M/MU/P/S d-(++) s: a-- C++(+++) UL P-- L+++>+++
question_id IN (2,10,3,6,4,5)
ORDER BY question_id (2,10,3,6,4,5)
Is there any way I can do that, so that the output of the query is
question_id, text
2 ...
10
3
6
4
5
Thanks for any help.
RDB
--
Reuben D. Budiardja
Dept. Physics and Astronomy
University of Tennesse
PHP, since it's
actually ship with the linux distro I'm using (RHEL 3).
Thanks in advance for any info.
RDB.
--
Reuben D. Budiardja
Dept. Physics and Astronomy
University of Tennesse, Knoxville, TN
---(end of broadcast)---
TIP 9: the pl
I don't se any obvious reason why I cannot do that. Any help?
Thanks.
--
Reuben D. Budiardja
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
varying(10)| not null
desc | character varying(100) |
mod_user | character varying(15)|
mod_time | timestamp with time zone | default now()
Primary key: or_code_table_pkey
Any help is greatly appreciated.
Thanks.
RDB
--
Reuben D. Budiardja
Department of Phys
the docs and googled but
haven't found anything.
Anyhelp is greatly appreciated. Thanks.
RDB
--
Reuben D. Budiardja
Department of Physics and Astronomy
The University of Tennessee, Knoxville, TN
-
/"\ ASCII Ribbon Campaign against HTML
insert into table (field) values (value);
> commit;
Yes, but I don't see how this is more efficient than what I said previously
(??)
Thanks though.
RDB
> On Wed, 25 Jun 2003, Reuben D. Budiardja wrote:
> > Hi,
> > I am developing application with PHP as the front end, PGSQ
ning error), so I can check on that and
> > do update instead.
>
> This kind of query should work; just leave out the "FROM dummy_table" bit.
> (in Oracle it would be "FROM dual").
Hi,
this seems to work. Thanks. Don't know why I didn't just try it. A
Hi
Does anyone else find the site postgresql.org kinda unreliable? Many times
it's stalled for a while. And it's not just today, but very often. It's
really frustrating especially when I regularly use it to look up
documentation.
Is there any mirror to the site ?
Thanks.
R
On Tuesday 01 July 2003 08:45 pm, Jean-Christian Imbeault wrote:
> Reuben D. Budiardja wrote:
> > Hi, not sure if this is answering your question, but I just asked similar
> > questions here. I asked about using INSERT WHERE NOT EXISTS (which you
> > can do in Post
On Tuesday 01 July 2003 09:25 pm, Jean-Christian Imbeault wrote:
> Reuben D. Budiardja wrote:
> > No, onlu *one* of them will fail, but yes, the other will then generate
> > error. So it really is a trade off. Another way would be to lock the
> > table, as other ha
On Tuesday 01 July 2003 08:47 pm, The Hermit Hacker wrote:
> On Tue, 1 Jul 2003, Reuben D. Budiardja wrote:
> > On Tuesday 01 July 2003 06:54 pm, The Hermit Hacker wrote:
> > > On Tue, 1 Jul 2003, Reuben D. Budiardja wrote:
> > > > On Tuesday 01 July 2003 06:
On Tuesday 01 July 2003 11:08 pm, Jean-Christian Imbeault wrote:
> Reuben D. Budiardja wrote:
> > INSERT INTO mytable
> > SELECT 'value1', 'value2'
> >WHERE NOT EXISTS
> > (SELECT NULL FROM mytable
> >
umn's datatypes do not match
>
> ---(end of broadcast)-------
> TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/docs/faqs/FAQ.html
--
Reuben D. Budiardja
Department of Physics and Astronomy
; > PostgreSQL that can encrypt the data with MD5?
> >
> > I would like to encrypt the data in PostgreSQL, so other program can
> > use the same function. Can anyone give me some hints? What key word
> > should I search in the document?
> >
> > Thansk!
--
Reube
d table using pgaccess and
type them in UPPER case for both column name and table name
Then I could not access from psql. After banging my head to the wall for
couple days, I then realize I have to use the double quotes. So somehow
pgaccess write the create table statements using doble quotes.
On Tuesday 05 August 2003 03:31 am, Jean-Christian Imbeault wrote:
> shreedhar wrote:
> > Is it necessary to uninstall previous version of PHP in my system.
>
> No,but a new recompile will probably over-write the version you have now.
>
> > Which is the better compatible ve
19 matches
Mail list logo