On Sunday 08 April 2007 12:47 pm, Karthikeyan Sundaram wrote:
> Hi Everybody,
>
>I am using Postgres 8.1.0 and I have a requirement.
>
> I have a table
>
> create table weekly_tbl (id int, week_flag bit(7) not null default
> '111');
>
> I want to create a function like this
>
> create fu
On 2/7/07, Karthikeyan Sundaram <[EMAIL PROTECTED]> wrote:
I don't want to compare with Oracle and postgres. But I have a
situation.
I am using psql command line tool supplied by postgres.
In Oracle I can say
select * from emp where emp_id = &1
Oracle will ask:
Enter a value
Am Sonntag, 4. Februar 2007 22.34 schrieb Karthikeyan Sundaram:
> Hi,
>
>I am new to postgres. I asked a question regarding multibyte display.
> I got only one response.
Which was correct and about complet when taking the amount of information
given into account. So nobody else did see a ne
Hi,
I am new to postgres. I asked a question regarding multibyte display. I
got only one response.
Hence, I am re-iterating the question again to a larger audience.
We are using 8.2 release of postgres. Recently we converted our database to
multibyte on our dev machine. we want to test t
In article <[EMAIL PROTECTED]>,
Allan Kamau <[EMAIL PROTECTED]> writes:
> Hi all,
> I am looking for a way of selecting records from a
> table comprising of pairing fields having unique
> semantics, where the pair of values of lets say 'left'
> and 'right' and another pair having values of 'right'
Hi all,
I am looking for a way of selecting records from a
table comprising of pairing fields having unique
semantics, where the pair of values of lets say 'left'
and 'right' and another pair having values of 'right'
and 'left' is considered as duplicates as they have
the same meaning.
Below is m
http://gborg.postgresql.org/project/psqlodbc/genpage.php?howto-vblo
Mario Alberto Soto Cordones wrote:
Hi,
i need inser a picture in a table but i can´t.
i work with visual basic 6.0 and postgres 7.3 but i can´t
Thanks
Mario
---(end of broadcast)--
Jodi Kanter wrote:
Can someone tell me how to create a query that will list values in a
field across columns instead of listing them in row form. Can this be
done in one sql query? Thanks Jodi
Are you referring to a crosstab, i.e.:
select * from cth;
id | rowid |rowdt| attribut
"Brett W. McCoy" <[EMAIL PROTECTED]> writes:
>> select field, length(field) from table where length(field) < 10;
>>
>> How many times is the length() function called for each row? Once or
>> twice?
> I would expect it to run both times.
More specifically, the one in the select list will be eva
On Fri, 25 Jan 2002, Bolt Thrower wrote:
> In the query:
>
> select field, length(field) from table where length(field) < 10;
>
> How many times is the length() function called for each row? Once or
> twice?
I would expect it to run both times.
I did a similar query with an explain:
ex
On Fri, 25 Jan 2002, Bolt Thrower wrote:
> In the query:
>
> select field, length(field) from table where length(field) < 10;
>
> How many times is the length() function called for each row? Once or
> twice?
Pretty sure it'll be twice.
---(end of broadcast)-
In the query:
select field, length(field) from table where length(field) < 10;
How many times is the length() function called for each row? Once or
twice?
Thanks,
--
Steve Chadsey <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 2: you
In the query:
select field, length(field) from table where length(field) < 10;
How many times is the length() function called for each row?
Once or twice?
Thanks,
--
Steve Chadsey <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 5: Have
13 matches
Mail list logo
