On Thu, Feb 03, 2011 at 02:26:10PM +0530, Adarsh Sharma wrote:
> globe=# CREATE FUNCTION user10() RETURNS void AS'
> globe'# DECLARE
> globe'# BEGIN
> globe'# create table user_news_new as select
> record_id,field_name,field_value,news_date from user_news where
> field_name in ('SOI','RelLoc','Desc
Dear all,
I am able to execute command successfully through CLI or pgAdmin .
*create table user_news_new as select
record_id,field_name,field_value,news_date from user_news where
field_name in ('SOI','RelLoc','Description','Heading','news_date') and
field_value != '' ; *
But I don't know wh
--On Dienstag, Juli 08, 2008 15:12:44 +0200 "Leif B. Kristensen"
<[EMAIL PROTECTED]> wrote:
Is this the case on both Windows and Linux? - that psql uses more for
paging, as opposed to doing it itself?
It uses "less" on Linux.
Seems to me that less is the default on cygwin, only. For others
On Tuesday 8. July 2008, Raymond O'Donnell wrote:
>On 08/07/2008 13:17, Bernd Helmle wrote:
>> psql uses more to paginate results of your SELECT command. Seems
>> like
>
>Is this the case on both Windows and Linux? - that psql uses more for
>paging, as opposed to doing it itself?
It uses "less" on
On 08/07/2008 13:17, Bernd Helmle wrote:
psql uses more to paginate results of your SELECT command. Seems like
Is this the case on both Windows and Linux? - that psql uses more for
paging, as opposed to doing it itself?
Ray.
-
--On Dienstag, Juli 08, 2008 21:46:53 +1000 Long Cui
<[EMAIL PROTECTED]> wrote:
I installed Postgresql 8.3.3 in windows XP, try to input some commands in
windows command prompt. The create, update and insert command work all
right, just select command.got the error message: "more" is not inte
On Tuesday 8. July 2008, Long Cui wrote:
>HI
>
>I installed Postgresql 8.3.3 in windows XP, try to input some commands
> in windows command prompt. The create, update and insert command
> work all right, just select command.got the error message: "more" is
> not internal or external command, not
am Tue, dem 08.07.2008, um 21:46:53 +1000 mailte Long Cui folgendes:
> HI
>
> I installed Postgresql 8.3.3 in windows XP, try to input some commands in
> windows command prompt. The create, update and insert command work all right,
> just select command.got the error message: "more" is not inte
HI
I installed Postgresql 8.3.3 in windows XP, try to input some commands in
windows command prompt. The create, update and insert command work all
right, just select command.got the error message: "more" is not internal or
external command, not runnable program or bat file. Why did I input like
--- On Sun, 10/21/07, Adrian Klaver <[EMAIL PROTECTED]> wrote:
> > I have a column with data structured as follows.
> >
> > 32TT - 0002
> > 32LT- 0004
> > 32PT-0005
> >
> > Is there a way of selecting all of the rows containing
> LT in that column??
> >
> > I have attempted variations of ' *LT* ' w
On Sunday 21 October 2007 2:32 pm, Bob Pawley wrote:
> I have a column with data structured as follows.
>
> 32TT - 0002
> 32LT- 0004
> 32PT-0005
>
> Is there a way of selecting all of the rows containing LT in that column??
>
>
> I have attempted variations of ' *LT* ' with out success.
>
> Bob Paw
Bob Pawley wrote:
> I have a column with data structured as follows.
>
> 32TT - 0002
> 32LT- 0004
> 32PT-0005
>
> Is there a way of selecting all of the rows containing LT in that column??
>
>
> I have attempted variations of ' *LT* ' with out success.
LIKE '%LT%' perhaps?
Or ~ 'LT' (unanchor
I have a column with data structured as follows.
32TT - 0002
32LT- 0004
32PT-0005
Is there a way of selecting all of the rows containing LT in that column??
I have attempted variations of ' *LT* ' with out success.
Bob Pawley
13 matches
Mail list logo