Re: New from mssql. Help please

I've tried it, but nothing happen, just display some text says "less:not
found" What's wrong?

I use version 7.3.1.

PostgreSQL 7.3.1 on i686-pc-cygwin, compiled by GCC gcc (GCC) 3.2
20020927 (prerelease)

Should I upgrade?

Thanks.

-----Original Message-----

From: pgsql-novice-owner(at)postgresql(dot)org [
<mailto:pgsql-novice-owner(at)postgresql(dot)org>
mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Joe Erickson

Sent: Jumat, 21 Mei 2004 19:40

To: hendro; pgsql-novice(at)postgresql(dot)org

Subject: Re: [NOVICE] New from mssql. Help please

In psql, you can do a \da to list aggregate functions, like max() and
sum(), and \df to list functions. This is probably not the best way to
learn the functions though. A good web site that lists functions is
<http://www.postgresql.org/docs/7.4/interactive/functions.html>
http://www.postgresql.org/docs/7.4/interactive/functions.html

-----Original Message-----

From: pgsql-novice-owner(at)postgresql(dot)org [
<mailto:pgsql-novice-owner(at)postgresql(dot)org]On>
mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of hendro

Sent: Friday, May 21, 2004 3:50 AM

To: pgsql-novice(at)postgresql(dot)org

Subject: [NOVICE] New from mssql. Help please

Hi,

I'm new here.

My major problem is working with functions. (previously I use SQL

Server)

For instance, I haven't find a way to alter a function, or to view
function list. (any keystroke like \d that will display functions ?) Can
anybody suggest a nice place to start? An URL perhaps?

BTW, \? returns nothing in psql. How come?

Thanks

Hendro

---------------------------(end of broadcast)---------------------------

TIP 5: Have you checked our extensive FAQ?

<http://www.postgresql.org/docs/faqs/FAQ.html>
http://www.postgresql.org/docs/faqs/FAQ.html

---------------------------(end of broadcast)---------------------------

TIP 2: you can get off all lists at once with the unregister command

(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

I've tried it, but nothing happen, just display some text says "less:not
found" What's wrong? My use version 7.3.1. Should I upgrade?

version

------------------------------------------------------------------------
-----------------

PostgreSQL 7.3.1 on i686-pc-cygwin, compiled by GCC gcc (GCC) 3.2
20020927 (prerelease)

Thanks.

-----Original Message-----

From: pgsql-novice-owner(at)postgresql(dot)org [
<mailto:pgsql-novice-owner(at)postgresql(dot)org>
mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Joe Erickson

Sent: Jumat, 21 Mei 2004 19:40

To: hendro; pgsql-novice(at)postgresql(dot)org

Subject: Re: [NOVICE] New from mssql. Help please

In psql, you can do a \da to list aggregate functions, like max() and
sum(), and \df to list functions. This is probably not the best way to
learn the functions though. A good web site that lists functions is
<http://www.postgresql.org/docs/7.4/interactive/functions.html>
http://www.postgresql.org/docs/7.4/interactive/functions.html

-----Original Message-----

From: pgsql-novice-owner(at)postgresql(dot)org [
<mailto:pgsql-novice-owner(at)postgresql(dot)org]On>
mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of hendro

Sent: Friday, May 21, 2004 3:50 AM

To: pgsql-novice(at)postgresql(dot)org

Subject: [NOVICE] New from mssql. Help please

Hi,

I'm new here.

My major problem is working with functions. (previously I use SQL

Server)

For instance, I haven't find a way to alter a function, or to view
function list. (any keystroke like \d that will display functions ?) Can
anybody suggest a nice place to start? An URL perhaps?

BTW, \? returns nothing in psql. How come?

Thanks

Hendro

---------------------------(end of broadcast)---------------------------

TIP 5: Have you checked our extensive FAQ?

<http://www.postgresql.org/docs/faqs/FAQ.html>
http://www.postgresql.org/docs/faqs/FAQ.html

---------------------------(end of broadcast)---------------------------

TIP 2: you can get off all lists at once with the unregister command

(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

hendro wrote:
| I've tried it, but nothing happen, just display some text says "less:not
| found" What's wrong?

psql is trying to send the output of your command to a pager. A pager is
a program which displays output in a console one page at a time. The
default pager is called "less". To solve your problem, install the
cygwin less package.

| PostgreSQL 7.3.1 on i686-pc-cygwin, compiled by GCC gcc (GCC) 3.2
| 20020927 (prerelease)
|
| Should I upgrade?

If it's easy, sure. However, it sounds like you're just using it to play
around and learn postgres. So it's probably not worth going to the
effort if it's going to be a lot of work for you to upgrade. 7.4 offers
CREATE OR REPLACE FUNCTION which is the way to alter a function that you
were asking about below.

Andrew Hammond
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFAs7/Tgfzn5SevSpoRAr4hAJ4rnw1+CLIWjEjZlWgsVoCJvsWOUgCePnoj
fTXo32NKiPCnuR7EX25/+Nw=
=+LNp
-----END PGP SIGNATURE-----

Andrew Hammond wrote:

> hendro wrote:
> | I've tried it, but nothing happen, just display some text says "less:not
> | found" What's wrong?
>
> psql is trying to send the output of your command to a pager. A pager is
> a program which displays output in a console one page at a time. The
> default pager is called "less". To solve your problem, install the
> cygwin less package.
>
> | PostgreSQL 7.3.1 on i686-pc-cygwin, compiled by GCC gcc (GCC) 3.2
> | 20020927 (prerelease)
> |
> | Should I upgrade?
>
> If it's easy, sure. However, it sounds like you're just using it to play
> around and learn postgres. So it's probably not worth going to the
> effort if it's going to be a lot of work for you to upgrade. 7.4 offers
> CREATE OR REPLACE FUNCTION which is the way to alter a function that you
> were asking about below.

Also the 7.3 series have the CREATE OR REPLACE feature ( view and function ).

Regards
Gaetano Mendola