Skip to content

Instantly share code, notes, and snippets.

@chriscarter90
Last active August 29, 2015 14:23
Show Gist options
  • Save chriscarter90/605a6c681ec87a3e587b to your computer and use it in GitHub Desktop.
Save chriscarter90/605a6c681ec87a3e587b to your computer and use it in GitHub Desktop.
Postgres oddness
psql (9.4.1)
Type "help" for help.
defence-solicitor-service-auth_test=# SHOW LC_COLLATE;
lc_collate
-------------
en_US.UTF-8
(1 row)
defence-solicitor-service-auth_test=# SHOW LC_CTYPE;
lc_ctype
-------------
en_US.UTF-8
(1 row)
defence-solicitor-service-auth_test=# WITH x(t, e) AS (
defence-solicitor-service-auth_test(# VALUES
defence-solicitor-service-auth_test(# ('Bob Smith', 'bob.smith@b.com')
defence-solicitor-service-auth_test(# ,('BOB SMITH', 'bob.smith@a.com')
defence-solicitor-service-auth_test(# )
defence-solicitor-service-auth_test-# SELECT t
defence-solicitor-service-auth_test-# FROM x
defence-solicitor-service-auth_test-# ORDER BY e,t
defence-solicitor-service-auth_test-# ;
t
-----------
BOB SMITH
Bob Smith
(2 rows)
defence-solicitor-service-auth_test=# WITH x(t, e) AS (
defence-solicitor-service-auth_test(# VALUES
defence-solicitor-service-auth_test(# ('Bob Smith', 'bob.smith@b.com')
defence-solicitor-service-auth_test(# ,('BOB SMITH', 'bob.smith@a.com')
defence-solicitor-service-auth_test(# )
defence-solicitor-service-auth_test-# SELECT t
defence-solicitor-service-auth_test-# FROM x
defence-solicitor-service-auth_test-# ORDER BY t,e;
t
-----------
BOB SMITH
Bob Smith
(2 rows)
defence-solicitor-service-auth_test=# SELECT version();
version
-----------------------------------------------------------------------------------------------------------------------------------
PostgreSQL 9.4.1 on x86_64-apple-darwin14.1.0, compiled by Apple LLVM version 6.0 (clang-600.0.56) (based on LLVM 3.5svn), 64-bit
(1 row)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment