Hi
I have just installed 6.5, and I have a couple of questions that I cannot find
the answer to in the documentation.
Firstly, I am using temporary tables for a number of operations. Is
there a way to direct postgresql to keep these in memory for fast
access, or will it do this anyway?
Secondly
I am trying to insert both the date and the time into a datetime field.
If the field datetime in table v1 is dt, then the following successfully
inserts the date into the datetime field:
insert into v1 (date) values ('19990401') ;
However, if I also wanted to retain the time of day, the follow
I've read many postings of people having this same problem, which I am now
having since I've updated to LinuxPPC R5. At this point I've compiled a
completely NEW database from scratch (with no problems) and, following right
along in the install docs, run %initdb, %createdb, %psql (and then the
"se
"Matt Magoffin (Borders Online)" wrote:
>
> I've read many postings of people having this same problem, which I am now
> having since I've updated to LinuxPPC R5. At this point I've compiled a
> completely NEW database from scratch (with no problems) and, following right
> along in the install do
On Wed, 23 Jun 1999, abdelkrim wrote:
> it is possible to insert into a view ?
if its a single-table view, yes -- you'd want to create a DO INSTEAD rule.
consult the manual/html pages to get the proper syntax for CREATE RULE.
if its a multitable view, maybe... i dont think this can be done with
it is possible to insert into a view ?
thanks
Constantin Teodorescu
FLEX Consulting Braila,ROMANIA
In JDBC2 you do have the notion of arrays, but I've yet to get to them.
The only real way is to convert the Double[] to a string using
PostgreSQL's array syntax (which I can't remember what it looks like at
the moment), then store it using PreparedStatement.setString()
Peter
Peter
--
Peter Mou
