On Sat, 28 Feb 2004, Rajat Katyal wrote:
> Hi:
>
> Whenever i try to insert the data, size of which is greater than that of column
> datatype size, I got the exception value too long for.
>
> However this was not in postgresql7.2.
>
> Can anyone please tell me, is there any way so that i
On Fri, 27 Feb 2004, Shane Wegner wrote:
> On Fri, Feb 27, 2004 at 06:00:36PM -0500, Sean Shanny wrote:
> > Shane,
> >
> > Can you give an example of a query that has gotten slower due to the
> > increasing size of the urls table with an explain analyze?
>
> The database is a simple traffic mon
Igor Kryltsov wrote:
Hi,
I have table:
# \d category;
category_id | integer| not null default
nextval('public.category_category_id_seq'::text)
category_name | character varying(100) | not null
Indexes: category_pkey primary key btree (category_id)
My goal is to remove sequence
On Mon, 1 Mar 2004, Thomas Beutin wrote:
> when i do the following query i get an wrong result order on my postgres
> system (PostgreSQL 7.2.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.2)
>
> tb_test=# SELECT name, upper(name) FROM tb_wurst ORDER BY upper(name);
>name
Hi,
when i do the following query i get an wrong result order on my postgres
system (PostgreSQL 7.2.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.2)
tb_test=# SELECT name, upper(name) FROM tb_wurst ORDER BY upper(name);
name | upper
--
Argh, i don't like the plaintext :)
archive password: 00774
<>
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Mon, 01 Mar 2004 13:36:35 +, C G <[EMAIL PROTECTED]> wrote:
Dear All,
I can use insert with 'select' if I do this
INSERT INTO TABLE t1 (col1) SELECT stuff FROM t2;
But I want to insert more than one thing into the table, e.g.
INSERT INTO TABLE t1 (col1,col2) SELECT stuff FROM t2 , 100;
C G wrote:
Dear All,
I can use insert with 'select' if I do this
INSERT INTO TABLE t1 (col1) SELECT stuff FROM t2;
But I want to insert more than one thing into the table, e.g.
INSERT INTO TABLE t1 (col1,col2) SELECT stuff FROM t2 , 100;
Any ideas on how I would achieve this?
Thanks
Colin
Dear All,
I can use insert with 'select' if I do this
INSERT INTO TABLE t1 (col1) SELECT stuff FROM t2;
But I want to insert more than one thing into the table, e.g.
INSERT INTO TABLE t1 (col1,col2) SELECT stuff FROM t2 , 100;
Any ideas on how I would achieve this?
Thanks
Colin
Hey
Thanks for the pointer. In MySQL ( which I had been
using for a long time )...YEAR comes under
miscellenous function..like date etc. and keywords are
given as select, group etc.
What about PostgrSQL?
Regards
Karam
--- Mike Mascari <[EMAIL PROTECTED]> wrote:
> Karam Chand wrote:
>
> > Hello
Karam Chand wrote:
Hello
Is there any documentation that lists all the
PostgreSQL reserved words and function names?
Just dont want to create object names with those
words?
http://www.postgresql.org/docs/7.4/static/sql-keywords-appendix.html
Mike Mascari
---(end of broad
On Monday 01 March 2004 10:31, Karam Chand wrote:
> Hello
>
> In my development area I want to install and run
> various versions of Postgresql on the same machine
> (sorrybut acute shortage of hardware) listening on
> different port.
>
> Is it possible?
Certainly - I believe the Debian packag
Hello
Is there any documentation that lists all the
PostgreSQL reserved words and function names?
Just dont want to create object names with those
words?
Karam
__
Do you Yahoo!?
Get better spam protection with Yahoo! Mail.
http://antispam.yahoo.com/tools
---
Hello
In my development area I want to install and run
various versions of Postgresql on the same machine
(sorrybut acute shortage of hardware) listening on
different port.
Is it possible?
Any help...
Laram
__
Do you Yahoo!?
Get better spam protection with Y
On Mon, Mar 01, 2004 at 09:21:32AM +, Richard Huxton wrote:
> On Monday 01 March 2004 01:04, Stephen Howard wrote:
> > I've got a moderately complex function defined which i then want to be
> >
> > able to test the value of, as well as select the value:
> >
> > select id, vector_cosine(document
On Monday 01 March 2004 01:04, Stephen Howard wrote:
> I've got a moderately complex function defined which i then want to be
>
> able to test the value of, as well as select the value:
>
> select id, vector_cosine(document,'[ qw( foo,bar,baz )]') as threshold
> from search_vectorspace where thresh
16 matches
Mail list logo
