Timeline for Pull data from multiple tables in a view or function
Current License: CC BY-SA 3.0
14 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 23, 2017 at 12:40 | history | edited | CommunityBot |
replaced http://stackoverflow.com/ with https://stackoverflow.com/
|
|
| Jan 2, 2015 at 4:26 | history | edited | Erwin Brandstetter | CC BY-SA 3.0 |
typo, add link, trim noise
|
| Jul 14, 2014 at 14:17 | comment | added | alexsmn | I already have a question on here, I tried to the function, but I got stuck not knowing what type to return, dba.stackexchange.com/questions/71429/… | |
| Jul 14, 2014 at 14:14 | comment | added | Erwin Brandstetter |
@uhn-nohn: Create an SQL function with a date parameter and RETURNS TABLE and replace now()::date with $1. Examples: stackoverflow.com/questions/11862936/…, stackoverflow.com/questions/11401749/…. If you are still stuck, write a new question here. Comments are not the place for new questions.
|
|
| Jul 14, 2014 at 9:55 | comment | added | alexsmn | What is the best way of creating a variable instead of now()::date, so I can pass a date into that variable, and get data based on its value? | |
| Jul 12, 2014 at 1:05 | history | edited | Erwin Brandstetter | CC BY-SA 3.0 |
Explanation wasn't clear enough
|
| Jul 11, 2014 at 23:13 | history | edited | Erwin Brandstetter | CC BY-SA 3.0 |
clarify
|
| Jul 11, 2014 at 16:09 | history | edited | Erwin Brandstetter | CC BY-SA 3.0 |
format
|
| Jul 11, 2014 at 15:24 | comment | added | Erwin Brandstetter |
@uhn-nohn: Yes, in this case the column name is ambiguous and you need to switch to explicit ON syntax in the join condition instead of the shorter USING.
|
|
| Jul 11, 2014 at 14:57 | comment | added | alexsmn |
(keyword_id, project_id, created_at) here I get common column name "created_at" appears more than once in left table but If I remove it is working fine, It could be because I have on the project_keyword a column created_at?
|
|
| Jul 11, 2014 at 14:54 | vote | accept | alexsmn | ||
| Jul 11, 2014 at 14:39 | history | edited | Erwin Brandstetter | CC BY-SA 3.0 |
added 79 characters in body
|
| Jul 11, 2014 at 14:33 | history | edited | Erwin Brandstetter | CC BY-SA 3.0 |
explain
|
| Jul 11, 2014 at 14:15 | history | answered | Erwin Brandstetter | CC BY-SA 3.0 |