File:RECURSIVE (43321721355).jpg
Original file (1,175 × 1,500 pixels, file size: 1.22 MB, MIME type: image/jpeg)
Captions
Summary
[edit]DescriptionRECURSIVE (43321721355).jpg |
Recurcive CTEs (Common Table Expressions) are a powerful construct within PostgreSQL, it defined in the WITH clause. CTEs allows to work with temporary set of data and transform it. In our case query collects all rags except hat from the girl, and combines it one set without duplicates :) "" is not equal operator "array_agg" conctatinates input values into array "dictinct" removes duplicates values I've made an example to play with CTEs <a href="http://sqlfiddle.com/#!17/f2ea4c/1" rel="noreferrer nofollow">sqlfiddle.com/#!17/f2ea4c/1</a> |
Date | |
Source | RECURSIVE |
Author | Exey Panteleev from Moscow, Russia |
Camera location | 55° 52′ 33.58″ N, 37° 32′ 08.9″ E | View this and other nearby images on: OpenStreetMap | 55.875994; 37.535805 |
---|
Licensing
[edit]- You are free:
- to share – to copy, distribute and transmit the work
- to remix – to adapt the work
- Under the following conditions:
- attribution – You must give appropriate credit, provide a link to the license, and indicate if changes were made. You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.
This image was originally posted to Flickr by Exey Panteleev at https://flickr.com/photos/79275080@N00/43321721355 (archive). It was reviewed on 17 May 2019 by FlickreviewR 2 and was confirmed to be licensed under the terms of the cc-by-2.0. |
17 May 2019
File history
Click on a date/time to view the file as it appeared at that time.
Date/Time | Thumbnail | Dimensions | User | Comment | |
---|---|---|---|---|---|
current | 22:23, 17 May 2019 | 1,175 × 1,500 (1.22 MB) | Piotr Bart (talk | contribs) | Transferred from Flickr via #flickr2commons |
You cannot overwrite this file.
File usage on Commons
There are no pages that use this file.
Metadata
This file contains additional information such as Exif metadata which may have been added by the digital camera, scanner, or software program used to create or digitize it. If the file has been modified from its original state, some details such as the timestamp may not fully reflect those of the original file. The timestamp is only as accurate as the clock in the camera, and it may be completely wrong.
Camera manufacturer | Canon |
---|---|
Camera model | Canon EOS 5D Mark II |
Exposure time | 1/125 sec (0.008) |
F-number | f/8 |
ISO speed rating | 2,000 |
Date and time of data generation | 15:44, 22 October 2016 |
Lens focal length | 30 mm |
Orientation | Normal |
Horizontal resolution | 300 dpi |
Vertical resolution | 300 dpi |
Software used | Adobe Photoshop CC (Windows) |
File change date and time | 03:23, 24 August 2018 |
Exposure Program | Manual |
Exif version | 2.21 |
Date and time of digitizing | 15:44, 22 October 2016 |
APEX shutter speed | 6.965784 |
APEX aperture | 6 |
APEX exposure bias | 0 |
Maximum land aperture | 4 APEX (f/4) |
Metering mode | Pattern |
Flash | Flash did not fire, compulsory flash suppression |
DateTime subseconds | 89 |
DateTimeOriginal subseconds | 89 |
DateTimeDigitized subseconds | 89 |
Color space | sRGB |
Focal plane X resolution | 3,849.2117888965 |
Focal plane Y resolution | 3,908.1419624217 |
Focal plane resolution unit | inches |
Custom image processing | Normal process |
Exposure mode | Manual exposure |
White balance | Manual white balance |
Scene capture type | Standard |
Serial number of camera | 3531726307 |
Lens used | EF17-40mm f/4L USM |
Rating (out of 5) | 0 |
Date metadata was last modified | 06:23, 24 August 2018 |
Unique ID of original document | FFFF98F67737C4A30005F93CDFF4D9B7 |
IIM version | 65,469 |