Skip to content

Instantly share code, notes, and snippets.

@brahn
Last active December 21, 2015 01:19
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save brahn/2f56ddde241dbc6a2ece to your computer and use it in GitHub Desktop.
Save brahn/2f56ddde241dbc6a2ece to your computer and use it in GitHub Desktop.
stripe=# select * from pg_proc where proname = 'to_datestamp';
-[ RECORD 1 ]---+--------------------------------------------------------
proname | to_datestamp
pronamespace | 2200
proowner | 42479392
prolang | 14
procost | 100
prorows | 0
provariadic | 0
protransform | -
proisagg | f
proiswindow | f
prosecdef | f
proleakproof | f
proisstrict | f
proretset | f
provolatile | v
pronargs | 1
pronargdefaults | 0
prorettype | 1082
proargtypes | 701
proallargtypes |
proargmodes |
proargnames | {time_int}
proargdefaults |
prosrc |
| SELECT date_trunc('day', to_timestamp($1))::date;
|
probin |
proconfig |
proacl |
select * from pg_proc where proname = 'to_datestamp_immutable';
-[ RECORD 1 ]---+--------------------------------------------------------
proname | to_datestamp_immutable
pronamespace | 2200
proowner | 42479392
prolang | 14
procost | 100
prorows | 0
provariadic | 0
protransform | -
proisagg | f
proiswindow | f
prosecdef | f
proleakproof | f
proisstrict | f
proretset | f
provolatile | i
pronargs | 1
pronargdefaults | 0
prorettype | 1082
proargtypes | 701
proallargtypes |
proargmodes |
proargnames | {time_int}
proargdefaults |
prosrc |
| SELECT date_trunc('day', to_timestamp($1))::date;
|
probin |
proconfig |
proacl |
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment