[GENERAL] Thank you

2016-11-23 Thread Melvin Davidson
*This is not a problem or a query.*

*Here in the U.S.A. it is the day before Thanksgiving. In keeping with
that, I'd like to thank all those that have helped me, be thankful for all
those I have helped, and forgive all those that have refused to see my
point of view.*


*Happy Thanksgiving to everyone.*
-- 
*Melvin Davidson*
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.


Re: [GENERAL] thank you

2013-08-20 Thread Alisa

  Hi,
   why do  you connect one table with the other? They are't any 
relations between them. So I don't understand your point, I am somewhat 
confused, you can refer to the following site:

http://www.postgresql.org/docs/9.0/static/queries-table-expressions.html
   http://my.oschina.net/Kenyon/blog/79543

Ya i got the answer here is the code


SELECT *
FROM (SELECT row_number() over(), * FROM employee) t1
right outer JOIN (SELECT row_number() over(), * FROM managers) t2 on
t1.row_number=t2.row_number



Thank you



--
View this message in context: 
http://postgresql.1045698.n5.nabble.com/Here-is-my-problem-tp5766954p5767787.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.







--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[GENERAL] thank you

2013-08-19 Thread Basavaraj
Ya i got the answer here is the code


SELECT *
FROM (SELECT row_number() over(), * FROM employee) t1
right outer JOIN (SELECT row_number() over(), * FROM managers) t2 on
t1.row_number=t2.row_number



Thank you



--
View this message in context: 
http://postgresql.1045698.n5.nabble.com/Here-is-my-problem-tp5766954p5767787.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[GENERAL] Thank you

2009-04-02 Thread dfx

Thank you very much to all people!!!

I reached the goal using lynx to dowload the rpms and then
the "An Almost Idiots's Guide To PostgreSQL YUM" from Postgres OnLine 
Journal


Domenico

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] thank you

2007-12-19 Thread Erik Jones


On Dec 19, 2007, at 2:43 AM, Dave Page wrote:


Joshua D. Drake wrote:

On Wed, 19 Dec 2007 12:20:32 +0900
Paul Lambert <[EMAIL PROTECTED]> wrote:


I'm just disappointed that I finish up work with my current employer
on Friday and where I am going I won't get to work with PG anymore
and thus won't have as much opportunity to interact with the PG
community.


That is until I can convince my new employer to realise the dark  
side

of Microsoft SQL Server. :)


503-667-4564 extension 101... I am available anytime after 9:00am PST


Now there's a blatant plug if ever I saw one. That's one in hand  
for EDB!!


:-)

(and in case that one gets missed: :-) )

/D


Hah! :P

Erik Jones

Software Developer | Emma®
[EMAIL PROTECTED]
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com



---(end of broadcast)---
TIP 4: Have you searched our list archives?

  http://archives.postgresql.org/


Re: [GENERAL] thank you

2007-12-19 Thread Pedro Doria Meunier
I second that!
A BIG THANK YOU for you Postgresql folks out there and since the season
is up:
Merry Christmas and a Happy New Year!

On Tue, 2007-12-18 at 21:26 -0500, Kevin Hunter wrote:

> Hullo List,
> 
> This is aimed at everyone in this community who contributes to the
> Postgres project, but especially at the core folks who continually make
> this community great through energy, time, money, responses, and
> what-have-you.
> 
> I see lots of "Thank you"s go by for this problem or that conundrum
> solved, but I don't think I've seen a general thank you for all that all
> y'all do.  (If I've missed them in the blur of emails I get, I do
> apologize.)  Thank you for all that you do.
> 
> Thank you for the countless times you've saved my butt from my own
> stupidity.  Thank you for the absolute awesome help you've been while
> tracking down bugs.  Thank you for signing the NDA without fuss and
> searching my DB for a bug that I may have caused.  Thank you for
> answering my frustrated emails at some ungodly hour of the morning (do
> you sleep?!).  Thank you for engaging others in discussion, sometimes
> beyond the point of annoyance ... your enthusiasm and love for the
> project is duly noted. Thank you for constantly preaching "the right
> way".  Thank you . . . well you get the drift.  I'll stop before this
> turns into some chain-letter type ordeal.
> 
> The point is that I hope you realize just how much you all mean to the
> community.
> 
> Kevin
> 
> 
> ---(end of broadcast)---
> TIP 4: Have you searched our list archives?
> 
>http://archives.postgresql.org/

--
Pedro Doria Meunier 
Ips da Olaria
Edf. Jardins do Garajau, 4 r/c Y
9125-163 Caniço
Madeira
Portugal
GSM: +351 96 17 20 188 Skype: pdoriam
http://www.madeiragps.com


signature.asc
Description: This is a digitally signed message part


Re: [GENERAL] thank you

2007-12-19 Thread Dave Page
Joshua D. Drake wrote:
> On Wed, 19 Dec 2007 12:20:32 +0900
> Paul Lambert <[EMAIL PROTECTED]> wrote:
> 
>> I'm just disappointed that I finish up work with my current employer
>> on Friday and where I am going I won't get to work with PG anymore
>> and thus won't have as much opportunity to interact with the PG
>> community.
> 
>> That is until I can convince my new employer to realise the dark side
>> of Microsoft SQL Server. :)
> 
> 503-667-4564 extension 101... I am available anytime after 9:00am PST

Now there's a blatant plug if ever I saw one. That's one in hand for EDB!!

:-)

(and in case that one gets missed: :-) )

/D

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings


Re: [GENERAL] thank you

2007-12-19 Thread Shane Ambler

Joshua D. Drake wrote:

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On Tue, 18 Dec 2007 19:31:57 -0700
Kevin Kempter <[EMAIL PROTECTED]> wrote:


The point is that I hope you realize just how much you all mean to
the community.

Kevin


I'll second that. Plus thank you for a database system that's a joy
to work with.

/Kevin (Although not the same Kevin as above)


/me takes note of all the Kevins that are handing out hugs...

:)



Yup .. I'll dish out a dose o' them too..

;-)


--

Shane Ambler
pgSQL (at) Sheeky (dot) Biz

Get Sheeky @ http://Sheeky.Biz

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

  http://www.postgresql.org/docs/faq


Re: [GENERAL] thank you

2007-12-18 Thread Colin Wetherbee

Gregory Williamson wrote:

Kevin H. wrote on Tue 12/18/2007 7:26 PM

 > Hullo List,
 >
 > This is aimed at everyone in this community who contributes to the
 > Postgres project, but especially at the core folks who continually make
 > this community great through energy, time, money, responses, and
 > what-have-you.

<...snipped...>

 > The point is that I hope you realize just how much you all mean to the
 > community.
 >

+1


+1 from me, too.  I haven't been here long, but I enjoy reading the 
threads, and I've gained quite a lot of insight from the few threads in 
which I've been involved.  I don't even use databases professionally -- 
I'm a stock trader -- but, I have been interested in PostgreSQL for 
personal projects for a long time.  I'm glad I'm finally involved in a 
community where I can learn from other peoples' experience and interact 
with those people on a sort of informal but still professional level. 
Thanks go out to Tom, Joshua, Merlin, and the rest of the big names on 
the list.


Colin


---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster


Re: [GENERAL] thank you

2007-12-18 Thread brian

Joshua D. Drake wrote:

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On Wed, 19 Dec 2007 12:20:32 +0900
Paul Lambert <[EMAIL PROTECTED]> wrote:


That is until I can convince my new employer to realise the dark side
of Microsoft SQL Server. :)



503-667-4564 extension 101... I am available anytime after 9:00am PST

Sincerely,

Joshua D. Drake


Now THAT is an upstanding gesture. Well done, sir!

(AND he arrives to work early!)

all the best,
brian

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

  http://www.postgresql.org/docs/faq


Re: [GENERAL] thank you

2007-12-18 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On Wed, 19 Dec 2007 12:20:32 +0900
Paul Lambert <[EMAIL PROTECTED]> wrote:

> I'm just disappointed that I finish up work with my current employer
> on Friday and where I am going I won't get to work with PG anymore
> and thus won't have as much opportunity to interact with the PG
> community.
> 
> That is until I can convince my new employer to realise the dark side
> of Microsoft SQL Server. :)

503-667-4564 extension 101... I am available anytime after 9:00am PST

Sincerely,

Joshua D. Drake

- -- 
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ 
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
SELECT 'Training', 'Consulting' FROM vendor WHERE name = 'CMD'


-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHaJCmATb/zqfZUUQRAsPqAJ46VFZBcuEyg2XpYdeAlZkUYRqARQCfS9ly
A6fL44YcDr+wSI7LCbRNmrk=
=spdE
-END PGP SIGNATURE-

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings


Re: [GENERAL] thank you

2007-12-18 Thread Erik Jones


On Dec 18, 2007, at 8:26 PM, Kevin Hunter wrote:


Hullo List,

This is aimed at everyone in this community who contributes to the
Postgres project, but especially at the core folks who continually  
make

this community great through energy, time, money, responses, and
what-have-you.

I see lots of "Thank you"s go by for this problem or that conundrum
solved, but I don't think I've seen a general thank you for all  
that all

y'all do.  (If I've missed them in the blur of emails I get, I do
apologize.)  Thank you for all that you do.

Thank you for the countless times you've saved my butt from my own
stupidity.  Thank you for the absolute awesome help you've been while
tracking down bugs.  Thank you for signing the NDA without fuss and
searching my DB for a bug that I may have caused.  Thank you for
answering my frustrated emails at some ungodly hour of the morning (do
you sleep?!).  Thank you for engaging others in discussion, sometimes
beyond the point of annoyance ... your enthusiasm and love for the
project is duly noted. Thank you for constantly preaching "the right
way".  Thank you . . . well you get the drift.  I'll stop before this
turns into some chain-letter type ordeal.

The point is that I hope you realize just how much you all mean to the
community.


I'll second and third and ... everything he just said!  Over the past  
couple of years I've come to realize that PostgreSQL's greatest  
strength is that it is more than software, or even open source  
software -- the software is really just the gold nugget at the center  
of a vibrant community of individuals help, explain things, explain  
things again, explain things again :), crack jokes, get to know each  
other and so much more.  To the core team:  thanks for continuing to  
make this possible, to everyone:  thanks for making it all happen!


Erik Jones

Software Developer | Emma®
[EMAIL PROTECTED]
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com



---(end of broadcast)---
TIP 6: explain analyze is your friend


Re: [GENERAL] thank you

2007-12-18 Thread Ow Mun Heng

On Tue, 2007-12-18 at 20:12 -0700, Gregory Williamson wrote:
> Kevin H. wrote on Tue 12/18/2007 7:26 PM
> > This is aimed at everyone in this community who contributes to the
> > Postgres project, but especially at the core folks who continually
> make this community great through energy, time, money, responses, and
> > what-have-you.
> 
> <...snipped...>
> 
> > The point is that I hope you realize just how much you all mean to
> the community.
> >
> 
> +1
+1

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster


Re: [GENERAL] thank you

2007-12-18 Thread Paul Lambert

Gregory Williamson wrote:

Kevin H. wrote on Tue 12/18/2007 7:26 PM

 > Hullo List,
 >
 > This is aimed at everyone in this community who contributes to the
 > Postgres project, but especially at the core folks who continually make
 > this community great through energy, time, money, responses, and
 > what-have-you.

<...snipped...>

 > The point is that I hope you realize just how much you all mean to the
 > community.
 >

+1

Greg Williamson



+2

I'm just disappointed that I finish up work with my current employer on 
Friday and where I am going I won't get to work with PG anymore and thus 
won't have as much opportunity to interact with the PG community.


That is until I can convince my new employer to realise the dark side of 
 Microsoft SQL Server. :)


--
Paul Lambert
Database Administrator
AutoLedgers - A Reynolds & Reynolds Company


---(end of broadcast)---
TIP 6: explain analyze is your friend


Re: [GENERAL] thank you

2007-12-18 Thread Gregory Williamson
Kevin H. wrote on Tue 12/18/2007 7:26 PM

> Hullo List,
> 
> This is aimed at everyone in this community who contributes to the
> Postgres project, but especially at the core folks who continually make
> this community great through energy, time, money, responses, and
> what-have-you.

<...snipped...>

> The point is that I hope you realize just how much you all mean to the
> community.
> 

+1

Greg Williamson


Re: [GENERAL] thank you

2007-12-18 Thread Martin Gainty
2 questions

NDA...what NDA??

I would suggest concentrating on implementing your contact page
(in other words publish the page only when it works correctly..)

M--
- Original Message -
From: "Kevin Kempter" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, December 18, 2007 9:31 PM
Subject: Re: [GENERAL] thank you


> On Tuesday 18 December 2007 19:26:40 Kevin Hunter wrote:
> > Hullo List,
> >
> > This is aimed at everyone in this community who contributes to the
> > Postgres project, but especially at the core folks who continually make
> > this community great through energy, time, money, responses, and
> > what-have-you.
> >
> > I see lots of "Thank you"s go by for this problem or that conundrum
> > solved, but I don't think I've seen a general thank you for all that all
> > y'all do.  (If I've missed them in the blur of emails I get, I do
> > apologize.)  Thank you for all that you do.
> >
> > Thank you for the countless times you've saved my butt from my own
> > stupidity.  Thank you for the absolute awesome help you've been while
> > tracking down bugs.  Thank you for signing the NDA without fuss and
> > searching my DB for a bug that I may have caused.  Thank you for
> > answering my frustrated emails at some ungodly hour of the morning (do
> > you sleep?!).  Thank you for engaging others in discussion, sometimes
> > beyond the point of annoyance ... your enthusiasm and love for the
> > project is duly noted. Thank you for constantly preaching "the right
> > way".  Thank you . . . well you get the drift.  I'll stop before this
> > turns into some chain-letter type ordeal.
> >
> > The point is that I hope you realize just how much you all mean to the
> > community.
> >
> > Kevin
>
>
> I'll second that. Plus thank you for a database system that's a joy to
work
> with.
>
> /Kevin (Although not the same Kevin as above)
>
> ---(end of broadcast)---
> TIP 2: Don't 'kill -9' the postmaster
>


---(end of broadcast)---
TIP 6: explain analyze is your friend


Re: [GENERAL] thank you

2007-12-18 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On Tue, 18 Dec 2007 19:31:57 -0700
Kevin Kempter <[EMAIL PROTECTED]> wrote:

> > The point is that I hope you realize just how much you all mean to
> > the community.
> >
> > Kevin
> 
> 
> I'll second that. Plus thank you for a database system that's a joy
> to work with.
> 
> /Kevin (Although not the same Kevin as above)

/me takes note of all the Kevins that are handing out hugs...

:)

Sincerely,

Joshua D. Drake

- -- 
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ 
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
SELECT 'Training', 'Consulting' FROM vendor WHERE name = 'CMD'


-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHaIUHATb/zqfZUUQRAi2lAJ9Jp8AWTfjs2HBVbGhtyRyDS4Zx4gCePbEs
N0KcDkAWmNj/HYdEJkGtCiQ=
=nW2G
-END PGP SIGNATURE-

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings


Re: [GENERAL] thank you

2007-12-18 Thread Kevin Kempter
On Tuesday 18 December 2007 19:26:40 Kevin Hunter wrote:
> Hullo List,
>
> This is aimed at everyone in this community who contributes to the
> Postgres project, but especially at the core folks who continually make
> this community great through energy, time, money, responses, and
> what-have-you.
>
> I see lots of "Thank you"s go by for this problem or that conundrum
> solved, but I don't think I've seen a general thank you for all that all
> y'all do.  (If I've missed them in the blur of emails I get, I do
> apologize.)  Thank you for all that you do.
>
> Thank you for the countless times you've saved my butt from my own
> stupidity.  Thank you for the absolute awesome help you've been while
> tracking down bugs.  Thank you for signing the NDA without fuss and
> searching my DB for a bug that I may have caused.  Thank you for
> answering my frustrated emails at some ungodly hour of the morning (do
> you sleep?!).  Thank you for engaging others in discussion, sometimes
> beyond the point of annoyance ... your enthusiasm and love for the
> project is duly noted. Thank you for constantly preaching "the right
> way".  Thank you . . . well you get the drift.  I'll stop before this
> turns into some chain-letter type ordeal.
>
> The point is that I hope you realize just how much you all mean to the
> community.
>
> Kevin


I'll second that. Plus thank you for a database system that's a joy to work 
with.

/Kevin (Although not the same Kevin as above)

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster


[GENERAL] thank you

2007-12-18 Thread Kevin Hunter
Hullo List,

This is aimed at everyone in this community who contributes to the
Postgres project, but especially at the core folks who continually make
this community great through energy, time, money, responses, and
what-have-you.

I see lots of "Thank you"s go by for this problem or that conundrum
solved, but I don't think I've seen a general thank you for all that all
y'all do.  (If I've missed them in the blur of emails I get, I do
apologize.)  Thank you for all that you do.

Thank you for the countless times you've saved my butt from my own
stupidity.  Thank you for the absolute awesome help you've been while
tracking down bugs.  Thank you for signing the NDA without fuss and
searching my DB for a bug that I may have caused.  Thank you for
answering my frustrated emails at some ungodly hour of the morning (do
you sleep?!).  Thank you for engaging others in discussion, sometimes
beyond the point of annoyance ... your enthusiasm and love for the
project is duly noted. Thank you for constantly preaching "the right
way".  Thank you . . . well you get the drift.  I'll stop before this
turns into some chain-letter type ordeal.

The point is that I hope you realize just how much you all mean to the
community.

Kevin


---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org/


[GENERAL] Thank you for your email

2007-02-14 Thread Sujay Bhattacharya




I will be out of the office starting  02/09/2007 and will not return until
02/21/2007.

I am travelling and will be back in the office only after the Lunar New
Year. During this time, I will check my email and voicemail from time to
time; however, response may be delayed.

You can reach me on my mobile for emergencies. For IDC IT related issues,
please send a mail to Help Desk or contact Valerie @ +65-6829-7705.

For Goldmine or regional website issues, please contact Noopur @
+65-6829-7774.

Gong Xi Fa Cai!

Best regards,

Sujay




---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster


[GENERAL] Thank you

2005-01-20 Thread Vikram Singh
My friend started a small e-learning company and asked
me to develop the IT solution. The company is now 5
years old and postgresql has been in use for the last
4 years. In the past 4 years NOT ONCE has postgresql
crashed on us. We have had times when the server
utilization was at 100% and swap was being used as
memory but postgresql kept going. 

Today, we have a quite a few high profile clients
(fortune 50) with hundreds of their employees using
our system to keep their skills updated. We are
excited about the 8.0 release and will be upgrading
soon. I would like to thank the postgresql team for
delivering a rock solid DBMS. 



__ 
Do you Yahoo!? 
All your favorites on one personal page – Try My Yahoo!
http://my.yahoo.com 

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


Re: [GENERAL] Thank you!

2003-08-20 Thread alvherre
See the attached file for details
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


Re: [GENERAL] Thank you!

2003-08-20 Thread ler
Please see the attached file for details.
---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org


[GENERAL] Thank you for your service....

2001-09-30 Thread 진희 김


Thank you for your mailing service

But I do not want your mailing service

Please don't send mail. 


Have a nice day.. :)

_
¼±¹°, ÀüÅë³îÀÌ, Ãß¼®À½½Ä, ±³ÅëÁ¤º¸, °¡Á·¿©Çà- ¾ßÈÄ! ÇÑ°¡À§ Å׸¶°¡À̵å
http://kr.theme.yahoo.com/
°í½ºÅé, Ç㸮ÄÉÀÎ21, Æ÷ÄϺ¼, ´ÙÀ̾Ƹóµå...
Áö±Ý, ´ëÇѹα¹ÀÌ Áñ°Å¿î ÀÌÀ¯ - ¾ßÈÄ! °ÔÀÓ 
http://kr.games.yahoo.com/

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



[GENERAL] Thank you:)

2001-05-07 Thread Christian Marschalek

Thanks to all who helped me with my questions... I sometimes forget /
loose track so I'll do it this way ;)You know who you are :)


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html