Hi,
instead of cast(mostype as varchar) try mostype::varchar
Thanks
Sreelatha
On Sun, Apr 4, 2010 at 10:04 PM, Pavel Stehule wrote:
> 2010/4/4 Scott Geller :
> > Hi
> >
> > I have the following plpgsql function that works:
> >
> > DROP TYPE if exists distr CASCADE;
> > CREATE TYPE distr AS (b
On Sun, Apr 04, 2010 at 08:03:13PM -0700, Wang, Mary Y wrote:
> I still don't get it. I do want a zero for the subversion_flags to be stored
> in the table. But it returned an error because it didn't like
> subversion_flags='' in the UPDATE SQL statement.
>
> subversion_flags | integer
On Sun, Apr 4, 2010 at 10:23 PM, Scott Marlowe wrote:
> On Sun, Apr 4, 2010 at 9:03 PM, Wang, Mary Y wrote:
>> I still don't get it. I do want a zero for the subversion_flags to be
>> stored in the table. But it returned an error because it didn't like
>> subversion_flags='' in the UPDATE SQL
On Sun, Apr 4, 2010 at 9:03 PM, Wang, Mary Y wrote:
> I still don't get it. I do want a zero for the subversion_flags to be stored
> in the table. But it returned an error because it didn't like
> subversion_flags='' in the UPDATE SQL statement.
>
> subversion_flags | integer | not null
I still don't get it. I do want a zero for the subversion_flags to be stored
in the table. But it returned an error because it didn't like
subversion_flags='' in the UPDATE SQL statement.
subversion_flags | integer | not null default 0
Mary
-Original Message-
From: Tom Lane
"Wang, Mary Y" writes:
> Can someone provide a link to the Postgres 8.x documentation that provides
> information about Null vs. Empty String?
> Here is the situation:
> Currently, the source code performs the following SQL statement :
> UPDATE user_group set subversion_flags='' WHERE user_id='5
Can someone provide a link to the Postgres 8.x documentation that provides
information about Null vs. Empty String?
Here is the situation:
Currently, the source code performs the following SQL statement :
UPDATE user_group set subversion_flags='' WHERE user_id='5818' AND
group_id='438';
(This SQ
On 04/05/10 01:44, Björn Lindqvist wrote:
Subject: Completely wrong row estimates
Hello everybody,
Here is the EXPLAIN ANALYZE output for a simple query in my database
running on postgres 8.3.9:
EXPLAIN ANALYZE
SELECT * FROM word w JOIN video_words vw ON w.id = vw.word_id
WHERE w.word = 'tagt
2010/4/4 Björn Lindqvist :
> Subject: Completely wrong row estimates
>
> Hello everybody,
>
> Here is the EXPLAIN ANALYZE output for a simple query in my database
> running on postgres 8.3.9:
>
> EXPLAIN ANALYZE
> SELECT * FROM word w JOIN video_words vw ON w.id = vw.word_id
> WHERE w.word = 'tagt
Subject: Completely wrong row estimates
Hello everybody,
Here is the EXPLAIN ANALYZE output for a simple query in my database
running on postgres 8.3.9:
EXPLAIN ANALYZE
SELECT * FROM word w JOIN video_words vw ON w.id = vw.word_id
WHERE w.word = 'tagtext';
QUERY PLAN
--
We are using proxool for many deployments, we were using DBCP but proxool is
better in terms of features.
On Mon, Mar 29, 2010 at 10:34 AM, Wappler, Robert wrote:
> On 2010-03-29, David Kerr wrote:
>
> > On 3/27/2010 12:46 AM, John R Pierce wrote:
> >> Allan Kamau wrote:
> >>> You may also have a
Ankuj Gupta writes:
> I installed it using yum. I had a look at the /etc/profile file but it
> didn't have $PGDATA .
In an RPM install the data directory is typically going to be
/var/lib/pgsql/data/. There may not be anything there yet if you
haven't started the postmaster once already. I conc
2010/4/4 Scott Geller :
> Hi
>
> I have the following plpgsql function that works:
>
> DROP TYPE if exists distr CASCADE;
> CREATE TYPE distr AS (b bigint, var varchar);
>
> DROP FUNCTION IF EXISTS dist() cascade;
>
> CREATE or replace FUNCTION dist() RETURNS setof distr
> AS $$ begin
> return que
I found out . Its is in /var/lib/pgsql/data .
On Sun, Apr 4, 2010 at 10:00 PM, Scott Marlowe wrote:
> I'm pretty sure it's in /var/lib/pgsql on fedora, but I won't make a
> bet. You can use locate to find it (maybe):
>
> sudo locate postgresql.conf
>
> On Sun, Apr 4, 2010 at 10:18 AM, Ankuj Gu
Hi,
is there a "proper" domain for regular expressions? At the
moment I'm using:
| CREATE DOMAIN RegularExpression AS TEXT CHECK('' ~ VALUE OR '' !~ VALUE);
which works.
Tim
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www
I'm pretty sure it's in /var/lib/pgsql on fedora, but I won't make a
bet. You can use locate to find it (maybe):
sudo locate postgresql.conf
On Sun, Apr 4, 2010 at 10:18 AM, Ankuj Gupta wrote:
> I installed it using yum. I had a look at the /etc/profile file but it
> didn't have $PGDATA .
>
>
>
I installed it using yum. I had a look at the /etc/profile file but it
didn't have $PGDATA .
On Sun, Apr 4, 2010 at 9:44 PM, Scott Marlowe wrote:
> On Sun, Apr 4, 2010 at 10:02 AM, Ankuj Gupta wrote:
> > Hi!!
> >
> > I have to configure the postmaster daemon to accept TCP connection.For
> that
Hi
I have the following plpgsql function that works:
DROP TYPE if exists distr CASCADE;
CREATE TYPE distr AS (b bigint, var varchar);
DROP FUNCTION IF EXISTS dist() cascade;
CREATE or replace FUNCTION dist() RETURNS setof distr
AS $$ begin
return query EXECUTE 'Select count(*) as b, cast(most
On Sun, Apr 4, 2010 at 10:02 AM, Ankuj Gupta wrote:
> Hi!!
>
> I have to configure the postmaster daemon to accept TCP connection.For that
> I will have to add -i and -o flag at the start but how do I accomplish this
> ? I am using Fedora 9.
How did you install pg? I'm guessing the easiest way i
Hi!!
I have to configure the postmaster daemon to accept TCP connection.For that
I will have to add -i and -o flag at the start but how do I accomplish this
? I am using Fedora 9.
Ankuj
20 matches
Mail list logo
