On Fri, Feb 23, 2001 at 04:28:40AM -0800, akif noor wrote:
>
> i have created a table having blob object but now i am
> not able to insert a picture into the table. Can you
> send me sql command to insert picture into the table i
> need syntax. i tried through DB2IMAGE but failed to
> insert.
>
Carlos Garcia writes:
> Hello, I working on your DB and I need to get some advanced data from the
> System Catalog.
> Pleace can you send me the system catalog or information.
http://www.postgresql.org/devel-corner/docs/postgres/catalogs.html
--
Peter Eisentraut [EMAIL PROTECTED] ht
> I want to set encoding hungarian language.
> I try to set LATIN2, but char order is "áabc..".
> The good order is "aábc...".
>
> What is the soultion?
configure PostgreSQL with --enable-locale option and rebuild it.
--
Tatsuo Ishii
Hello All!
I just included PL/Perl language in my database.
Created function:
CREATE FUNCTION and_with_mask(int2, int2) RETURNS int2 AS
'
return $_[0] &
$_[1]
' LANGUAGE 'plperl';
select and_with_mask(4,
Adam Haberlach wrote:
>
> One of the rocket scientests working on this project has
> created a system in which /either/ a description or a build
> number is stored in a text field. He has been writing reports
Get that man a job on son of star-wars!
> that use CAST AS('description', int
Adam Kornick wrote:
>
> SQL Gurus,
>
> I want to update a specific set of rows in a column with a list or
> vector. Something like,
>
> UPDATE some_table SET col = [1 2 3 4 5]
> WHERE some_condition_limits_to_five_rows;
Sorry mate - no, not on any system I can think of either. How is
Alessio Bragadini <[EMAIL PROTECTED]> writes:
> Q1: is there anyone out there with a ecpg_7.0.2-X_i386.deb available?
> Q2: are there anywhere Debian potato packages of recent releases?
What's wrong with getting the source debs for 7.0.x and building them
on your Potato system?
-Doug
"Steff" <[EMAIL PROTECTED]> writes:
> I'm starting using PostgreSQL and want to import datas from my old database.
> I've made ASCII delimited files and want to use the copy instruction.
>
> Having the server started, I do the following :
>
> > psql mydb
> >copy table from 'myfile' using delimi
Colleen Williams <[EMAIL PROTECTED]> writes:
> Hi,
>
> I have some questions regarding vacuum and backup...
> 1) Do we need to stop the postmaster process before we do a nightly
> vacuum analyze or pg_dump in version 7.0.3 of PostgreSQL?
No, not at all.
> (I read somewhere that we will end up
Richard Huxton <[EMAIL PROTECTED]> writes:
> > I'm looking for a workaround that will let him do his
> > "conversion" transparently: some form of atoi that will return
> > 0 if it finds no numbers instead of blowing up. Anyone got
> > one?
The proper solution, of course, is to slap him
On Sat, Feb 24, 2001 at 11:16:49AM +, Richard Huxton wrote:
> Adam Haberlach wrote:
> >
> > One of the rocket scientests working on this project has
> > created a system in which /either/ a description or a build
> > number is stored in a text field. He has been writing reports
>
>
Le 22.02.01 à 22:23, "Tom Lane" écrivait :
)> SELECT oid FROM pg_database WHERE datname = 'template1'
)
)> But this SELECT returns two tuples ! I have two identical tuples in
)> pg_database for template1.
)> Perhaps deleting one will help me, but which one (equal ?).
)
)This is definitely uncool,
Sorry for my stupid question, but I am a new user!
Which key should I use after qsql has displayed the result of a select
statement.
On the sceen i see my result and .
What key for continue which a new command?
On Sat, 24 Feb 2001 02:56, Renaud Tthonnart wrote:
> I 'd like create a type like a dynamic list.
chris=# \d+ xxx
Table "xxx"
Attribute | Type | Modifier | Description
---+---+--+-
num | integer
Hi,
I can't find the c++ example with Class and Function.
Where can I find it on the web?
Thanks in advance, Julio from Bulgaria.
Hi (Soma Interesting?)
I am also a developer here in Tokyo and have done few I-Mode websites using
PHP and mySQL. (I've used PostgreSQL with Japanese, but not for I-Mode)
( see www.japaninc.com/i )
There's no particular problems of storing the 2-bit data in your databases,
the only thing is that
What is wrong with the following function?
CREATE FUNCTION logfunc2 (text) RETURNS int AS '
DECLARE
text ALIAS FOR $1;
BEGIN
SELECT length(text);
RETURN ''3'';
END;
' LANGUAGE 'plpgsql';
I get the following error:
ERROR: U
17 matches
Mail list logo
