Search This Blog

Archive

Check out these Pages

yangonairportonline.com

yangonairportonline.com

Contact

lynnnayko@gmail.com

Double quotes column names in postgres




There are two reasons to use double quotes around column names in PostgreSQL
  1.  If the reserved words are used as the column names.
  2. PostgreSQL is case sensitive and all objects are regarded as lowercase unless double quotes are provided. Double quotes tells PostgreSQL to use the case given.
If you create a table

CREATE TABLE tt1 (
    id integer,
    "Order" integer
);

The above statement tell PostgreSQL that the "Order" column must be saved in that case.

The following INSERT statements will not work :-

INSERT INTO tt1 (id, Order) VALUES (1, 1)
INSERT INTO tt1 (id, "order") VALUES (2, 2)
INSERT INTO tt1 (id, "OrDer") VALUES (3, 3)
You will have to get the case correct :-

INSERT INTO tt1 (id, "Order") VALUES (1, 1)
INSERT INTO tt1 (id, "Order") VALUES (2, 2)
INSERT INTO tt1 (id, "Order") VALUES (3, 3)

This post is to be used as future reference myself and my other friends those whoever encountered this question.
Full credits to original questions and answers @ http://stackoverflow.com/a/6730803/4148663

Finding dhamma in Yangon

On
Under a scorching Sun and with our bare feet burnt from the tiled walkways we, a group of Thais, entered several pagodas and temples in Yangon and the suburban town of Thanlyin. However, we felt this trip was worth all the effort and sweat because we learnt much about the Lord Buddha's life and Buddhist art from Khatha Chinbunchon, a famous fortune-teller and PhD student in Buddhism.

Link URL: http://www.bangkokpost.com/travel/in-thailand/568551/finding-dhamma-in-yangon


Sent from my iPhone using Bangkok Post Mobile App.

Mel Carter - Hold Me, Thrill Me, Kiss Me



Thanks a lot to : One UnconditionalLove

Hold me, hold me
Never let me go
Until you've told me, told me
What I want to know
And then just hold me, hold me
Make me tell you I'm in love with you
(Hold me tight, never let me go)
Thrill me, thrill me
Walk me down the lane where shadows will be, will be
Hiding lovers just the same as we'll be, we'll be
When you make me tell you I love you
(Will you take me in your arms)
They told me, "Be sensible with your new love
Don't be fooled thinking this is the last you'll find"
But they never stood in the dark with you, love
When you take me in your arms
and drive me slowly out of my mind
Kiss me, kiss me, and when you do
I know that you will miss me, miss me
If we ever say adieu, so kiss me, kiss me
Make me tell you I'm in love with you....

Lyrics may be questionable....

Live Performance:
https://www.youtube.com/watch?v=DwGZHfMMXSQ

Hash 13

The roof